| René Nyffenegger's collection of things on the web | |
|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
SMON | ||
Starting the database
SMON checks the SCN in all datafile
headers when the database is started. Everything is OK if all of these SCNs matches the SCN found in the
controlfile. If the SCNs don't match, the database is in an inconsistent state.
SMON also frees temporary segments.
smon_scn_time
Every 5 minutes, SMON wakes up and fills sys.smon_scn_time
Misc
SMON also updates sys.col_usage$
(if _column_tracking_level is set to 1)
|