Re: Reading data from oracle database

On Dec 12, 3:23 am, oracle user <rcl..._at_gmail.com> wrote:
> Can anyone help me on understanding  how data is read from oracle
> database.There is a db writer process which writes data in the dbf
> files from dirty buffers. Similary what is the the mechanism for
> reading data from dbf files of oracle database.
>  If a user connect's to sqlplus session and gives the command 'select
> * from table x' ,what all process happens next.
> Thanks in Advance

So many good writers have documented this so well ... and you have questions?

Follow Mladen's and Joel's advice and you are on the path to enlightenment! Received on Sat Dec 13 2008 - 16:34:07 CST