Re: HELP! Can't kill session

Michael,

Marking the session for kill is the first part, on Unix the second part is to find the offending process 'ps -ef', and then kill the pid ie

kill -9 <pid>

Your session is now out of Oracle.

On Windows NT you can't do this, because you need to kill a thread of a process, rather than a process.

Chris

larionov_at_yahoo.com wrote:
>
> Hi,
>
> I have started some query yesterday from SQL*Plus
> and then I realized it is not what I want,
> so I pressed Ctrl-C, but it did not respond.
>
> When I try "ALTER SYSTEM KILL SESSION" I always get
>
> ERROR at line 1:
> ORA-00031: session marked for kill
>
> (I tried it about 50 times)
> It is still running and taking some system resources.
> It is highly undesirable to shut database down now.
>
> Please help me kill this session!
>
> I use Oracle 8.0322 on Solaris platform.
>
> Thank you!
>
> Michael.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Jan 28 1999 - 17:11:29 CST