You should be able to kill the oracle shadow process to release these
sessions. Something like select 'kill -9 '||p.spid from v$session s,
v$process p where s.status = 'KILLED' and s.paddr = p.addr will get you
a nice command list. Once the shadow process is killed the database
session will be released. We are an Oracle Apps site and kill JDBC
sessions which have been inactive for 3 hours via this kind of unix
level process kill as a ALTER SYSTEM KILL SESSION ends up with the kind
of "hung" KILLED sessions you are describing. Good luck.
Received on Thu May 26 2005 - 08:39:25 CDT
