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  >  System Architecture

 Print  |  
Question:  What do Database Buffers contain ?

Answer: Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.


September 09, 2006 05:32:38 #1
 manish hoiyani   Member Since: Visitor    Total Comments: N/A 

RE: What do Database Buffers contain ?
 

Database buffers:  It stores the most recently executed  blocks and apart from that, it stores the rollback blocks  which contains the previous record for those rows which have been updated.

Buffer also stores the dirty blocks means blocks which contains the new updated value which has been not yet committed by the user.

     

 

Back To Question