Re: Killing a runaway process on 7.3.2.2.0 for NT?

From: Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM>
Date: 1997/12/31
Message-ID: <68e6v3$83u$1@plutonium.btinternet.com>#1/1

Be patient , it might not be a runaway process, when you kill the process , it will have to rollback, if it has generated lots of rollback information then it will take just as long if not longer to rollback.

What makes you think it is a runaway process ? Check out the SQL it is running and check for obvious performance issues such as full table scans , lack of indexes , disk contention etc, Is it CPU or I/O bound ? Is the database SGA optimally tuned ?

Marc Vanhoecke wrote in message <68dpmr$94f$1_at_rhea.glo.be>...
>How can you kill a runaway process on a 7.3.2.2.0 Server for NT ?
> - I tried disconnecting with the instance manager,
>- Alter system kill session...
>
>The result is always the same,
> Session is marked for kill, but not terminated !
>
>The only option now left to me is a shutdown and a startup.
>
>Who can help me?
>
>Marc vanhoecke (B. Rekencentra N.V.)
>
>
>
Received on Wed Dec 31 1997 - 00:00:00 CST