How does Oracle know where to read from

From: amonte <ax.mount_at_gmail.com>
Date: Fri, 10 Apr 2009 22:51:51 +0200
Message-ID: <85c1fb130904101351j67d2f7a3jf70e9e071b534ea3_at_mail.gmail.com>

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?

Alex

--
http://www.freelists.org/webpage/oracle-l

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

This message: [ Message body ]
Next message: Mark W. Farnham: "www.appsperf.org E-business suite and Peoplesoft Workshops (pre-approved non-technical notice)"
Previous message: Pradeep Chetal: "RE: ** UNIX qu"
Next in thread: K Gopalakrishnan: "Re: How does Oracle know where to read from"
Reply: K Gopalakrishnan: "Re: How does Oracle know where to read from"
Reply: Mark W. Farnham: "RE: How does Oracle know where to read from"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message