Re: what happens internally when a sql statement is issued?

On 27 Aug 2003 23:33:23 -0700, hopehope_123_at_yahoo.com (utkanbir) wrote:

>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

Seems you are up to reverse engineering. Which is prohibited by your license...

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Aug 28 2003 - 01:42:16 CDT