2 Responses to Oracle Exadata Troubleshooting

  1. Rayaprolu says:

    Hello Tane,

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *