Re: Finding offending thread in MS Windows server

"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 use tlist.exe to show all threads for a specific process. It's in the Windows Resource kit, or in the /support/tools/support.cab file on the Windows 2000 CD.

HTH,
Matthias Hoys Received on Thu Nov 11 2004 - 11:31:51 CST