1Z0-062 · Question #267
Which three are activities performed by SMON?
The correct answer is A. cleaning up the database buffer cache and freeing resources that a client process was using B. applying online redo during instance recovery C. cleaning up temporary segments that are no longer needed. SMON (System Monitor) is a background process responsible for several critical maintenance tasks, primarily instance recovery and cleanup operations within the database.
Question
Which three are activities performed by SMON?
Options
- Acleaning up the database buffer cache and freeing resources that a client process was using
- Bapplying online redo during instance recovery
- Ccleaning up temporary segments that are no longer needed
- Dperforming database services registration with the default listener
- Erestartinga server or a dispatcher process that terminated abnormally
- Frecovering failed transactions that were skipped during instance recovery because of file-read or
How the community answered
(57 responses)- A91% (52)
- D5% (3)
- E2% (1)
- F2% (1)
Why each option
SMON (System Monitor) is a background process responsible for several critical maintenance tasks, primarily instance recovery and cleanup operations within the database.
SMON performs transaction recovery after instance recovery, which involves rolling back uncommitted transactions and implicitly cleaning up associated dirty buffers in the database buffer cache, along with other cleanup activities.
A primary function of SMON is to perform instance recovery after a crash, where it applies online redo log entries to data files to ensure database consistency.
SMON regularly cleans up temporary segments that are no longer in use, reclaiming space within the database.
Database service registration with the listener is handled by the PMON or LREG process, not SMON.
Restarting abnormally terminated server or dispatcher processes is a primary responsibility of the PMON process, not SMON.
SMON performs transaction recovery by rolling back uncommitted transactions after instance recovery, but it does not typically 'skip' transactions due to file-read errors during recovery in the way described.
Concept tested: Oracle SMON background process activities
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/process-architecture.html#GUID-354924F0-0610-4828-B086-C35B9A422D10
Topics
Community Discussion
No community discussion yet for this question.