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.


October 10, 2007 02:49:10 #2
 Mohammed Abdul Afroze   Member Since: Visitor    Total Comments: N/A 

RE: What do Database Buffers contain ?
 
Buffer Cache Stores the most recently used blocks of data. It can also have modified data that has not permenently written to disk. When a row in a table is updated the foreground server processes reads the datafile information on the disk in to the buffer cache. Hence modifying the data block in server memory. Oracle writes the block from the buffer cache to the LRU(Least Recently Used) Mechanism.
     

 

Back To Question