Forte Agent <1443131_at_usenetplanet.com> wrote in message news:<ld77p01alqbcb6adiumajgrlkkbist7htr_at_4ax.com>...
> We have Oracle DB 9.2.0.4 on Windows 2000 Server. Sometimes we see
> ORACLE.EXE taking up 100% of CPU time to time, practically bringing
> our server down to halt. Problem is, unlike UNIX, all Oracle
> processes in Windows run as a single ORACLE.EXE process, so we are
> having trouble finding out which database session is taking up CPU.
> Is there some way to identify offending session in Windows?
> Unfortunately, dynamic performance view such as v$session_wait is not
> helping too much.
>
> Since Oracle processes in Windows run as many threads spawned by a
> single ORACLE.EXE process, we are wondering if there is a way to
> pin-point exactly what thread is taking up CPU, and kill just that
> specific thread. Please let us know if there is a way. Thank you in
> advance.
You can dump the thread with this
=>http://support.microsoft.com/default.aspx?scid=kb;en-us;286350
Received on Fri Nov 12 2004 - 21:00:26 CST
