Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Kill zombie session

wucisMay 17 2011 — edited May 17 2011

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, OS is ubuntu 10.04 (lucid)

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 ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 14 2011

Added on May 17 2011

#apex, #database, #general-database-discussions

2 comments

2,765 views