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?
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.
http://docs.oracle.com/cd/E11882_01/ser ... .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
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Who is online
Users browsing this forum: No registered users and 10 guests