How does Oracle Server Process get data block Information

hello,

I have the following question:

When the Oracle server wants to retrieve the data he first looks up in the DB-block buffer of the SGA if the corresponding database blocks are loaded.
If not the Oracle Server Process has to load the corresponding database blocks in the DB block buffer.

Here my question occurs:

From where does the oracle server process get the information what databse blocks do contain the data which is requested for ?

Where is the information stored about what datafiles contains which database blocks?
I suppose that the information is stored in the data dictionary. But also for accessing the data dictionary the server has to get the information what database blocks to access and where these database blocks are located.

Maybe somebody does know an answer. Thanks in advance. Jochen Received on Fri Dec 04 1998 - 00:00:00 CST