Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!v5g2000prm.googlegroups.com!not-for-mail From: joel garry Newsgroups: comp.databases.oracle.server Subject: Re: Reading data from oracle database Date: Fri, 12 Dec 2008 10:54:38 -0800 (PST) Organization: http://groups.google.com Lines: 17 Message-ID: <3f485172-eae6-4056-8ce5-08d5643bc8aa@v5g2000prm.googlegroups.com> References: <0123ad30-2236-4300-91e3-23a694182e39@p2g2000prf.googlegroups.com> NNTP-Posting-Host: 75.49.200.201 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1229108078 7905 127.0.0.1 (12 Dec 2008 18:54:38 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 12 Dec 2008 18:54:38 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: v5g2000prm.googlegroups.com; posting-host=75.49.200.201; posting-account=tpQovAkAAABNoH5bwsZAiff2L0zxGwdv User-Agent: G2/1.0 X-HTTP-Via: 1.0 ISA2K4-OC1 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1),gzip(gfe),gzip(gfe) Xref: news.cambrium.nl On Dec 12, 12:23=A0am, oracle user wrote: > Can anyone help me on understanding =A0how 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. > =A0If 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