Re: RESOURCES ARE NOT FREED WHEN A SESSION DIES ABNORMALLY
From: Yong Huang <yong321_at_yahoo.com>
Date: Sat, 2 Aug 2008 06:20:09 -0700 (PDT)
Message-ID: <226984.93916.qm@web80604.mail.mud.yahoo.com>
Date: Sat, 2 Aug 2008 06:20:09 -0700 (PDT)
Message-ID: <226984.93916.qm@web80604.mail.mud.yahoo.com>
"alter system kill session" has the "immediate" option. It should remove the
session immediately. If orakill doesn't get rid of the Oracle process (OS
thread) immediately, Process Explorer allows you to kill a thread inside the
oracle.exe process.
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Aug 02 2008 - 08:20:09 CDT