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

LGWR (Log Writer) reads redo entries from the redo log buffer and writes them to online redo log files. ARCn copies filled redo logs to archive destinations. DBWn writes dirty buffers to data files. CKPT updates file headers with checkpoint info. PMON cleans up failed processes. SMON does instance recovery and space management.