what happens internally when a sql statement is issued?

Dear Gurus,

I want to know the steps that the oracle server applies when a sql statment is issued. I just want to learn the internal mechanism of oracle.
 I dont mean parse, execute etc, I want to know physical things such as the mechanism which answers the question : where is table ? whcih block ? where is the dictionary?
Imagine the db server runs and become online , shared memory is created , and first sql statment is invoked:

1. The dbserver must know the place of this table in order to read it. This information is probably in dictionary , but where is the dictionary?.how does db server the block location of dictionary ? ...

I will be appreciate if someone can help.

Kind Regards,
hope Received on Thu Aug 28 2003 - 01:33:23 CDT