Which background process is responsible for writing the dirty buffers to the database files?
1. DBWn
2. SMON
3. LGWR
4. CKPT
5. PMON
Answer 1 - The DBWn process writes the dirty buffers to the data files under two circumstances - when a checkpoint occurs or when the server process searches the buffer cache for a set threshold.
Saturday, 20 June 2009
Architecture and Administration Q009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment