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
superviks
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,
Vikram.
Previous Topic: Oracle 11G R2 Performance with Xeon E2603
Next Topic: Suitable Storage
Goto Forum:
  


Current Time: Tue Dec 12 05:34:06 CST 2017

Total time taken to generate the page: 0.01232 seconds