Re: Killed session not terminating?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 26 May 2005 15:54:26 +0200
Message-ID: <d74kef$ko4$01$1@news.t-online.com>

Mike Collier schrieb:
> 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.
>

Not regarding the OP, but nevertheless, if your requirements to end the sessions are so clear ( 3 hours idle ) - why don't you create a profile with restriction on idle time and forget about the idle sessions ?

Best regards

Maxim Received on Thu May 26 2005 - 08:54:26 CDT