Re: kill session doesn't work?

From the documentation on technet.oracle.com:

If the session is performing some activity that must be completed, such as waiting for a reply from a remote database or rolling back a transaction, Oracle waits for this activity to complete, marks the session as dead, and then returns control to you. If the waiting lasts a minute, Oracle marks the session to be killed and returns control to you with a message that the session is marked to be killed. The PMON background process then marks the session as dead when the activity is complete.

The session you're killing must be in the middle of a big workload!

Regards
HJR <twoplustwo_at_my-deja.com> wrote in message news:94vnab$k3f$1_at_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 - 18:47:18 CST