Re: kill session doesn't work?

From: wysza <awysza_at_yahoo.com>
Date: Sat, 27 Jan 2001 23:05:37 GMT
Message-ID: <5vIc6.5216$pb6.1324027@typhoon2.ba-dsg.net>

> alter system kill session ' 596, 21456' ;

                                       'sid,session#'  <-- from v$session

> The session continues to run...

How do you check if the session continues to run? Did you try to query DB from this session?
The rule is: if the session is not performing any transaction and you kill it, you can still see this session
listed in v$session view. But when you try to do anything with db from this killed session, you get ORA-00028' error. At this moment this session is gone from the view: v$session.

Hth
wysza

sorry for my english

<twoplustwo_at_my-deja.com> wrote in message news:94vd9a$c23$1_at_nnrp1.deja.com...
> My Oracle instance is running on unix
>
> WHen I try .....
> alter system kill session ' 596, 21456' ;
>
> The session continues to run...
> What else can I do to try to kill this session..?
>
>
> Thanks TwoplusTwo
>
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Jan 27 2001 - 17:05:37 CST