Re: Runaway Thread on NT, How to kill such sessions on NT, Orakill no good

"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
>
>

' The user session gets terminated by the server.'

Why?

'Orakill utility is not effective since Oracle does not have entry for that user's session anymore'

How does the user session get terminated by the server? If this is the case, you don't have any choice , but to stop/start the instance. Received on Mon Jul 01 2002 - 06:51:54 CDT