What is the purpose of SMON background process?

Options
- Performs crash recovery when a failed instance starts up again
- Performs recovery when a user process fails
- Both a and b
- Writes redo log entries to disk

CORRECT ANSWER : Performs crash recovery when a failed instance starts up again

Discussion Board
SMON (System Monitor Process)

SMON is the System Monitor which is responsible for recovering the system after a failure. It performs all system monitoring functions on the oracle database. Each time oracle is re-started, SMON performs a warm start and makes sure that the transactions that were left incomplete at the last shut down are recovered. SMON performs periodic cleanup of temporary segments that are no longer needed. The system monitor process (SMON) performs recovery, if necessary, at instance startup.

Prajakta Pandit 02-14-2017 12:04 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲