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: kill session doesn't work?

Re: kill session doesn't work?

From: <twoplustwo_at_my-deja.com>
Date: Sat, 27 Jan 2001 23:58:05 GMT
Message-ID: <94vnab$k3f$1@nnrp1.deja.com>

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

Original text of this message

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