Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! Can't kill session
I have same problems on 7.3.xxx on Windows NT.
I do a 'shutdown immediate' of the database, i can. It's the last solution.
larionov_at_yahoo.com a écrit:
> 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 - 16:03:48 CST