Could you please let me know that what exactly SMON process do? And what will happen if we kill it forcefully?
Kindly share your valuable views here, thanks in advance.
SMON does instance recovery in case of instance crash on subsequent instance startup and termination of any mandatory background process will lead to instance abort.
It is also used for Temp segment cleanup. Updates uet$ and fet$ tables as well.
When instance is crash due to any reason smon does automatic instance recovery on next startup of database and commited transaction it will reflect on your db uncommited transaction will be rollback.
SMON (system monitor) is a mandatory process there are various work of smon.
1> Smon perform instance recovery (from mount to open stage ) in the case of instance fail means roll foreword.
2> Clear and manage unused temporary segments.
3> Solve those transactions those skipped during crash in distributed database.
If you kill to smon process then your instance will be aborted/killed.
Sign up for STechies
Ask Question From Our Experts