GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle

 Print  |  
Question:  DB_BUFFER_CACHE and LIBRARY_CACHE

Answer: What is the main difference between the functions of DB_BUFFER_CACHE and LIBRARY_CACHE?


October 10, 2008 17:21:10 #1
 sumer77   Member Since: October 2008    Total Comments: 4 

RE: DB_BUFFER_CACHE and LIBRARY_CACHE
 

DB Buffer cache: 

when a query is executed then server process looks for block in buffer cache. If the block is not available in buffer cache then server process reads the block from data files.

Library cache:

It contains the informations of most recently used SQL and PL/SQLstatements and their parse statements and the execution plan are stored. 

     

 

Back To Question