Multiple choice technology web technology

Identify the background process which, is responsible for instance recovery

  1. System Monitor (SMON)

  2. Process Monitor (PMON)

  3. Database Writer (DBWR)

  4. Log Writer (LGWR)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

System Monitor (SMON) is the background process responsible for instance recovery in Oracle. When an Oracle instance fails (crash, power failure, etc.), SMON performs recovery on startup by rolling forward uncommitted changes from redo logs and rolling back uncommitted transactions. PMON handles process cleanup, DBWR writes data files, LGWR manages redo logs - none of these handle instance recovery.

Keep practicing — related questions