Multiple choice technology databases

Which process writes redo log buffer to redo log files?

  1. DBWR

  2. LGWR

  3. CKPT

  4. ARCH

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

LGWR (Log Writer) is the Oracle background process responsible for writing redo entries from the redo log buffer in the SGA to the online redo log files on disk. DBWR writes data blocks, CKPT is the checkpoint process, and ARCH archives redo logs. LGWR is the only process that writes redo log buffer to redo log files.