Finding offending thread in MS Windows server

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. Received on Thu Nov 11 2004 - 11:13:50 CST