Multiple choice technology packaged enterprise solutions

Which of the following background processes is used for coalescing free extents, in case dictionary managed tablespaces are used?

  1. Process Monitor

  2. Checkpoint

  3. Log Writer

  4. System Monitor

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

SMON (System Monitor) is the Oracle background process responsible for coalescing free extents in dictionary-managed tablespaces, consolidating adjacent free space into larger extents. Process Monitor (PMON) monitors processes, Checkpoint (CKPT) updates checkpoints, and Log Writer (LGWR) writes redo logs.