System Monitor Process (SMON) : Oracle Background Process.

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarAshiwini
  • 28 Jun, 2024
  • 0 Comments
  • 1 Min Read

System Monitor Process (SMON) : Oracle Background Process.

The System Monitor (SMON) process is one of the essential background processes in an Oracle database. It plays a crucial role in ensuring the database operates smoothly by handling a variety of tasks related to system maintenance and recovery. Below is an overview of the SMON process and its key functions:

Key Functions of the System Monitor Process (SMON)

The System Monitor (SMON) process is one of the essential background processes in an Oracle database. It plays a crucial role in ensuring the database operates smoothly by handling a variety of tasks related to system maintenance and recovery. Below is an overview of the SMON process and its key functions:

  • Instance Recovery
  • Cleaning Temporary Segments
  • Coalescing Free Space
  • Database Recovery Tasks
  • Dictionary Management
  • Offlining Unused Temporary Segments
  • Rolling Back Dead Transactions

The system monitor process (SMON) performs many database maintenance tasks, including the following:

  • Creates and manages the temporary tablespace metadata and reclaims space from orphaned temporary segments.
  • Maintains the undo tablespace by onlining, offlining, and shrinking the undo segments based on undo space usage Statistics.
  • Cleans up the data dictionary when it is in a transient and inconsistent state.
  • Maintains the system change number (SCN) to time mapping table that is used to support Oracle Flashback features.