Multiple choice technology programming languages

Which Oracle background process is responsible for coalescing free space?

  1. PMON

  2. SMON

  3. ARCH

  4. LGWR

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

SMON (System Monitor) is responsible for coalescing contiguous free space extents in tablespaces. PMON monitors and cleans failed processes, ARCH archives redo logs, and LGWR writes redo entries. Coalescing improves space utilization by merging adjacent free extents.