Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: kill session doesn't work?
I have another instance where it says it cannot complete the kill.. any ideas how to terminate the session....
SQL> alter system kill session '25,23645';
alter system kill session '25,23645'
*
ERROR at line 1:
ORA-00031: session marked for kill
Thanks TwoPlusTwo
In article <94vd9a$c23$1_at_nnrp1.deja.com>,
twoplustwo_at_my-deja.com wrote:
> 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/
>
Sent via Deja.com
http://www.deja.com/
Received on Sat Jan 27 2001 - 17:58:05 CST