Re: Reading data from oracle database
Date: Fri, 12 Dec 2008 10:54:38 -0800 (PST)
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.
-- @home.com is bogus. http://www.signonsandiego.com/uniontrib/20081212/news_1b12prgrn.htmlReceived on Fri Dec 12 2008 - 12:54:38 CST