Reading data from oracle database

From: oracle user <>
Date: Fri, 12 Dec 2008 00:23:54 -0800 (PST)
Message-ID: <>

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 Received on Fri Dec 12 2008 - 02:23:54 CST

Original text of this message