Re: Reading data from oracle database

On Dec 12, 12: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

I'd prefix Mladen's answer with "before you do anything else, read the Concepts manual, available at http://tahiti.oracle.com among other places." Then dive into Tom's book.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20081212/news_1b12prgrn.html