Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with Killing Sessions

Re: Help with Killing Sessions

From: Serge <rulsl_at_chat.ru>
Date: Wed, 17 Mar 1999 21:37:04 +0300
Message-ID: <7cosp1$84g$1@news2.aha.ru>


When oracle marks session 'KILLED', it means that session wasn't active at that moment.
The session will remain 'KILLED' until user tries to get access. In Oracle 7.3 you arn't be able to kill session at all by SQL means.

Robert Bucklin wrote <36EFE56D.6318BA22_at_bellsouth.net> ...
>When I kill a user session with the alter session command, either with
>the kill session or disconnect session option I am having trouble. The
>sessions do get killed. The problem is the session downt go away. It
>stays there with a status of KILLED. It also keeps the related UNIX
>process arount using up UNIX processes.
>
>How can I realy make a sesion go away?
>
>
>Bob B.
>
Received on Wed Mar 17 1999 - 12:37:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US