Home » Infrastructure » Hardware » How fetching a row happens in Exadata (Oracle Exadata V2)
How fetching a row happens in Exadata [message #619724] Thu, 24 July 2014 13:28
Messages: 1
Registered: July 2014
Location: Hyderabad
Junior Member
Hello Experts!!!

Good Day.

Suppose there is a Half-Rack Exadata machine with 4 DB and 7 Storage Nodes (Cells).

Suppose we issue a SELECT statement to query few rows of a table. My curiosity is how would the DB/Storage know exactly which cells to look for to fetch the queried rows without having to search all the 7 cells whether smart scan is being used or whether it isn't.

Warm Regards,
Previous Topic: Oracle 11G R2 Performance with Xeon E2603
Next Topic: Suitable Storage
Goto Forum:

Current Time: Sat Sep 30 00:50:37 CDT 2023