<<Previous Next>>
Oracle - What
is a database buffer cache? - June 27, 2009 at 11:00
AM
What is a database buffer
cache?
Database buffer cache is a component of SGA.
It has the responsibility to cache most recent accessed data. It
keeps the transaction in the buffer cache till it is written on the
disk.
Also read
What is configure command and recovery catalog?, What are
different types of backup? (Hot, Cold, logical, Physical)?, Whats
the Concept of Flashback Query in Oracle (10g in particular) and how
is it beneficial?...............
How do you increase the performance of %LIKE operator?, What is a
standby database? Difference between Physical and logical standby
databases, What is Cache Fusion Technology?, What is simple
replication and advance replication?.............
User process – User process is used in invocation of application
software, Data writing process - A database writer process is used
to write buffer content into a datafile. They are specifically used
to write “dirty block” to data files from the buffer................
| 
