Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!p2g2000prf.googlegroups.com!not-for-mail
From: oracle user <rcllnx@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Reading data from oracle database
Date: Fri, 12 Dec 2008 00:23:54 -0800 (PST)
Organization: http://groups.google.com
Lines: 8
Message-ID: <0123ad30-2236-4300-91e3-23a694182e39@p2g2000prf.googlegroups.com>
NNTP-Posting-Host: 203.196.159.122
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1229070234 30810 127.0.0.1 (12 Dec 2008 08:23:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 12 Dec 2008 08:23:54 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: p2g2000prf.googlegroups.com; posting-host=203.196.159.122; 
 posting-account=S0VY-woAAADWdWgLA3djz7A1WejQ2B05
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 2.0.50727; .NET CLR 3.0.04506.30),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

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