Re: HELP! Can't kill session

Have seen this on oracle 7 & 8 under aix, too. It is usually a drag b/c when we kill a session it is for a reason such as having become disconnected from its controlling terminal yet still holding resource locks thus blocking other processes. In a heavy oltp production environment shutdowns during business hours are not a good option; but usually after a while (up to 30 min or so) the zombie ultimately goes away. Assume that this is due to oracle doing cleanup, freeing locks, rolling back transactions, etc. Or maybe it just takes PMON a while to get around to doing this.
-thomas

In article <36B0DEC4.B56C2291_at_club-internet.fr>, Jean-Claude Matarazzo <jcmata_at_club-internet.fr> wrote:

> 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 - 17:24:16 CST