DB_BUFFER_CACHE and LIBRARY_CACHE

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

Questions by todeepakmalhotra   answers by todeepakmalhotra

Showing Answers 1 - 1 of 1 Answers

sumer77

  • Oct 24th, 2008
 

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. 

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions