René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -


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.


Every 5 minutes, SMON wakes up and fills sys.smon_scn_time


SMON also updates sys.col_usage$ (if _column_tracking_level is set to 1)