How does Oracle know where to read from

From: amonte <>
Date: Fri, 10 Apr 2009 22:51:51 +0200
Message-ID: <>

Hi all

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?


Received on Fri Apr 10 2009 - 15:51:51 CDT

Original text of this message