Home » RDBMS Server » Server Utilities » how to stop SMON
how to stop SMON [message #73076] Thu, 29 January 2004 05:36 Go to next message
bounty
Messages: 2
Registered: January 2004
Junior Member
I am a beginner at Oracle and would like to know if there is anyway for the SMON process to be stopped on a Win2000 Server.  When trying through Oracle Enterprise Manager Console it tells me that it is not a user session and fails to kill it.

This is Oracle 9i 32-bit on Win2000 and any tips would be greatly appreciated..

Cheers
Re: how to stop SMON [message #73077 is a reply to message #73076] Thu, 29 January 2004 05:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
dont do that.
SMON is one of the few IMPORTANT backgraround process which along with SGA forms the instance.
trying to kill SMON is trying to kill the instance.
Re: how to stop SMON [message #73078 is a reply to message #73076] Thu, 29 January 2004 06:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
if u want to bring down SMON, then
shutdown the datbase.
Re: how to stop SMON [message #73080 is a reply to message #73077] Fri, 30 January 2004 07:33 Go to previous messageGo to next message
bounty
Messages: 2
Registered: January 2004
Junior Member
Hi,
Thanks for your reply. I am aware that it may bring down the database. I need this only for a test but need to specifically kill that background process. Is it possible to kill the background process and have the database continue to run even if it is only for 30 seconds?

I am doing this on a test system of course and don't care if I have to completely uninstall/reinstall if it messing something up so badly.

Any help would be greatly appreciated.

Thank you
Re: how to stop SMON [message #73085 is a reply to message #73076] Sat, 31 January 2004 09:39 Go to previous message
Chris L
Messages: 7
Registered: January 2004
Junior Member
SMON is one of the 5 mandatory processes.
IF you killed it it would bring down the instance.
On Windows, the oracle processes are threaded together as one services so you cannot kill just one of the processes. You can on UNIX though.
Previous Topic: Different Charsets from Export 8.1.7 and Import 9.2
Next Topic: how create a 8.0.5 catalog schemas in oracle9i R2
Goto Forum:
  


Current Time: Mon Jul 01 16:06:34 CDT 2024