Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Runaway Thread on NT, How to kill such sessions on NT, Orakill no good
The NT Resource Kit has a 'process viewer'. You may not kill a thread but
you can reduce the thread priority to 0 (zero)
HTH
tED
"reza" <reza_at_digital-dispatch.co.uk> wrote in message
news:4NnT8.1099$LR.96244_at_news8-gui.server.ntli.net...
> Hi
> Our Oracle 8.1.6.3 server goes on a spin while a user application runs a
> piece of custom PL/Sql code.
> The indication are:
> The user session gets terminated by the server, and there is no entries in
> V$session or v$process for this session any more.
>
> However, on NT level still the thread created for the session is active
and
> uses the 99% of CPU and makes the server useless.
> Oracle does not respond to any new connection requst due to being 100%
busy
> internally.
> Orakill utility is not effective since Oracle does not have entry for that
> user's session anymore. If I use the Orakill it comes back with "...
killed
> Successfully" however the server does not recover.
>
> I have had runaway processes on Unix many times, which can be terminated
no
> problem, but I don't know how to terminate such runaway threads on NT. The
> only solution at the moment is to bounce the database.
>
> The offinsive code does not leave any ORA-xx error message behind, and
> further drilldown to the server shows that all the Background processes of
> the server are idle, and it is only the runaway thread of dead session is
> using the 99% of NT box's CPU.
>
> Many thanks in advance for any help on this matter
> Regards
> Reza
>
>
Received on Sun Jun 30 2002 - 07:40:13 CDT