How does Oracle know where to read from
Date: Fri, 10 Apr 2009 22:51:51 +0200
I have a probably very basic question but I cant think how Oracle does it.
When we query a table we know that data block address is hashed to read if buffer chain if reading from cache, otherwise look the rows in the data block address.
My question is when we run a query how is the data block address obtained? From where?
AlexReceived on Fri Apr 10 2009 - 15:51:51 CDT