| Kill zombie [message #507632] |
Tue, 17 May 2011 07:22  |
wucis
Messages: 60
Registered: March 2005
|
Member |
|
|
I had some procedures running from within thirdparty tool. The tool collapsed, but with top I see some sh <defunct> processes, namely zombies, which belong to the user oracle.
I'm using oracle-xe 10g with apex 2.1
I searched as user system where to find within oracle these processes, to kill them. But I could not find them. The procedures were not started with user system.
Where can I find those processes and how can I stop/kill/erase them ?
|
|
|
|
|
|
| Re: Kill zombie [message #507645 is a reply to message #507633] |
Tue, 17 May 2011 07:49  |
cookiemonster
Messages: 13921
Registered: September 2008
Location: Rainy Manchester
|
Senior Member |
|
|
Those processes should correspond to database sessions.
So use v$session to identify them and kill them with an
alter system kill session
command.
|
|
|
|
| Re: Kill zombie [message #507655 is a reply to message #507645] |
Tue, 17 May 2011 08:02 |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Of course, I highly doubt that the Oracle RDBMS will start "sh" processes, unless it's some shell scripts that get started with dmbs_scheduler. I guess they are old logins that got hung somehow.
The best bet would be to kill them (possibly with -9 if a straight kill doesn't work) from the Linux shell.
(Of course, only while wearing seat belts)
|
|
|
|
|
|
| Re: Kill zombie [message #507741 is a reply to message #507632] |
Tue, 17 May 2011 11:43 |
wucis
Messages: 60
Registered: March 2005
|
Member |
|
|
Luckily it was a test db. Even root could not kill the processes with option -9
Alter Session did not succeed.
I'm sure there was no console login to the db, cause I was the only user and just used apex/browser and the thirdparty tool.
I think the memory was not enough, so the tool was killed, maybe from the OS. Just the zombie remained, which I only got rid of by stopping the db and restart it again.
I'm curious for new suggestions to stop the zombies in a more civilized way. The problem is reproduceable.
|
|
|
|
| Re: Kill zombie [message #507744 is a reply to message #507741] |
Tue, 17 May 2011 12:10 |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
|
The first thing you would need to figure out is how those shell processes are started and why. When just apex/browser logins are used, there shouldn't be any sh processes. Someone was using a shell for something. Does that "third party tool" use or consist of shell scripts?
|
|
|
|
| Re: Kill zombie [message #507745 is a reply to message #507744] |
Tue, 17 May 2011 12:12 |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
|
Oh, and a possible suggestion: If that "third party tool" does "bad things" repeatedly, like hog all the memory, it might be a good Idea to not let it run as "oracle" user, but in a special user account that has a lower ulimit on memory so that it doesn't bring the database itself down.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
