Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP! Can't kill session
Mate Skoblar wrote:
> In article <7881pb$5d6$1_at_nnrp1.dejanews.com>, larionov_at_yahoo.com says...
> > 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
> >
>
> You have to wait until transaction rollback is complete, and that is why
> you get that error message. Session is already marked for kill, but you
> still have system activity because rollback is in progress.
I have the same situation. The killed session stayed there for 5 days until I
restart the database. It's not possible to spend 5 days or more to rollback.
Thanks for any advice,
River
novice DBA
Received on Tue Jan 26 1999 - 08:50:01 CST