Multiple choice technology programming languages

The CKPT process is optional; which process assumes these duties if CKPT is not active?

  1. PMON

  2. SMON

  3. ARCH

  4. LGWR
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When the CKPT (checkpoint) process is not active, the LGWR (Log Writer) process assumes its checkpoint duties. LGWR signals DBWR to write dirty buffers and updates checkpoint information in data file headers. PMON monitors processes, SMON handles instance recovery and free space coalescing, and ARCH archives redo logs - none of these handle checkpointing.

AI explanation

Correct answer: LGWR. The Checkpoint process (CKPT) is an optional Oracle background process that offloads the job of updating datafile headers and the control file with checkpoint information. If CKPT is not running, the Log Writer (LGWR) performs these checkpoint-related updates itself in addition to its normal redo-writing duties. PMON handles process recovery/cleanup, SMON handles instance recovery and space management, and ARCH archives filled redo logs — none of these take over checkpoint bookkeeping.

Keep practicing — related questions