select statement

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 27
Joined: Sun Aug 05, 2012 11:45 am

select statement

Postby vivek_k47 » Wed Nov 07, 2012 10:30 am

Can u please explain how the Select statement works in Oracle(how is it processed)
Also How does the server process know whether the data required is in the buffer cache or not?Which process keeps track of the data present in the DBBC?

Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: select statement

Postby Tim... » Wed Nov 07, 2012 11:54 am


That's not the sort of question you can answer with a couple of paragraphs in a forum. You probably need to start by reading this section of the concepts manual. ... .htm#i8709

Regarding the buffer cache, there are basically two options here:

- Direct Path Reads: Some operations bypass the buffer cache completely and read the information directly into the UGA.
- Everything else: An attempt is made to read the block from the cache. If it's not present, it is read from disk into the cache.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 1 guest