Multiple choice

Which of the following is not a responsibility of DBWR process?

  1. Defers writes for I/O optimization

  2. Uses a LRU algorithm to keep most recently used blocks in memory

  3. Writes to database redo log files as people COMMIT data

  4. Writes all changed (i.e. dirty) buffers to datafiles
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The DBWR (Database Writer) process writes dirty buffers to datafiles, uses LRU algorithm for buffer management, and can defer writes for I/O optimization. Writing to redo log files is the responsibility of LGWR (Log Writer), not DBWR. LGWR writes redo entries as users COMMIT data. This is a fundamental separation of duties in Oracle's process architecture.

Keep practicing — related questions