Reading data from oracle database
From: oracle user <rcllnx_at_gmail.com>
Date: Fri, 12 Dec 2008 00:23:54 -0800 (PST)
Message-ID: <0123ad30-2236-4300-91e3-23a694182e39@p2g2000prf.googlegroups.com>
Date: Fri, 12 Dec 2008 00:23:54 -0800 (PST)
Message-ID: <0123ad30-2236-4300-91e3-23a694182e39@p2g2000prf.googlegroups.com>
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