Q
Problem solve Get help with specific problems with your technologies, process and projects.

Why is database not functioning when SMON is killed

The SMON does instance recovery, coalescing and cleaning temporary segments. My question is I'm using a locally-managed...

tablespace for a system tablespace. Assume the database is running and now I kill the SMON background process. Why is Oracle not functioning as SMON now has no role to play in the database? * No instance recovery is needed as the database is running. * TABLESPACES are LMT -- no coalescing is needed including system tablespace.

Can you advice on why the database is not functioning when the SMON is killed?
Even though you may not need SMON at any particular point in time, it is a required process like PMON, LGWR, DBWn and CKPT. While you may be using all LMTs, SMON does still have a role to play. It cleans up temporary sort segments. And it also performs recovery if needed. But the real reason that you need this process running is that the Oracle kernel is coded to crash the instance if this process is not running. You can't change this code. Therefore, when you kill SMON, the instance will crash. Leave SMON up and running. It will determine if it has work to do. If it does not have work to do, then it sits there, essentially idle.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close