| Kaiz |
Posted: Apr 01, 2008 03:11:31 AM |
Total Post: 104
Joined: Sep, 2007
|
Dear Friends,
When the database is up and running , how can we kill smon? If i kill smon what will happened?
Thanks & regards... |
|
|
 Murtuja |
| Posted: Apr 01, 2008 05:13:04 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
If you kill a default background process then this may cause the database to be down.
|
|
|
|
|
| Kaiz |
| Posted: Apr 02, 2008 08:26:52 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Thanks but I can understand and know to kill the user but how can one kill the SMON or matter of fact any Background Process....
Thanks & Regards..
|
|
|
|
|
| Murtuja |
| Posted: Apr 02, 2008 08:49:33 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
ps -ef|grep smon
oracle 29922 1 0 Mar 26 ? 0:29 ora_smon_compass
kill -9 29922
|
|
|
|
|
| avnish |
| Posted: Apr 03, 2008 02:06:39 AM | |
|
Total Post: 50
Joined: Dec, 2007
|
Hi,
You can kill a background process by this command also
alter system shutdown immediate 'process'; \\process like D0001
Murtuja & Taj please right me if i m wrong.
Thanks & Regards
Avnish
|
|
|
|
|
| Kaiz |
| Posted: Apr 03, 2008 08:03:06 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Dear Murtuja
Thanks for the answer ... but I am using XP I am not getting command...
ps -ef|grep smon
Thanks and Regards
|
|
|
|
|
| Murtuja |
| Posted: Apr 03, 2008 09:02:02 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
Avnish,
I think you are telling about "alter system kill session <session id>"
There no such command like alter system shutdown immediate 'process'
|
|
|
|
|
| Murtuja |
| Posted: Apr 03, 2008 09:03:42 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
For windows
orakill <sid> <spid>
|
|
|
|
|
| Murtuja |
| Posted: Apr 03, 2008 09:09:38 AM | |
|
Total Post: 814
Joined: Jan, 2006
|
orakill <sid> <spid>
you can find out spid by this query
select * from v$process where program like '%SMON%'
You should only use orakill in cases where access to the database to execute ALTER SYSTEM KILL SESSION isn't possible. If you accidentally kill one of the required background processes, such as SMON, you'll probably crash the database.
|
|
|
|
|
| avnish |
| Posted: Apr 04, 2008 12:58:05 AM | |
|
Total Post: 50
Joined: Dec, 2007
|
Hi Murtuja,
This command actually i use for killing one of dispatcher process. I am not fully sure thru this query,other processes might be kill or not.
Thanks & Regards
AVNISH
|
|
|
|
|
| avnish |
| Posted: Apr 04, 2008 01:01:43 AM | |
|
Total Post: 50
Joined: Dec, 2007
|
For Query Syntax
please check on google or one of these links
http://www.freelists.org/archives/oracle-l/09-2005/msg00001.html
OR
http://www.ss64.com/ora/system_a.html
|
|
|
|
|
| Kaiz |
| Posted: Apr 04, 2008 10:20:09 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
