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

"utkanbir" <hopehope_123_at_yahoo.com> wrote in message news:f6c90ebe.0308272233.4dfa9ce7_at_posting.google.com...

> statment is issued. I just want to learn the internal mechanism of
> oracle.

"just"?

> 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 ? ...
>

Read the Concepts guide. It explains all you need to know on this subject. Once you've done that, extrapolate the rest and come back here for confirmation.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam