Multiple choice technology databases

Which background process reads the redo log buffer and writes it to a file ?

  1. ARCn

  2. DBWn

  3. CKPT

  4. LGWR

  5. PMON

  6. SMON

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Log Writer (LGWR) background process is responsible for writing the contents of the redo log buffer in the SGA to the active online redo log files. DBWn writes data blocks, CKPT updates headers/controlfiles, and ARCn copies filled logs.