Databases Reference
In-Depth Information
Monitoring Threads on Windows
Problem
You want to identify and monitor the threads related to an Oracle instance in Windows.
Solution
You can use a number of tools that show threads. There is one that comes with the Windows Resource Kit, but this
is not part of the Windows distribution; you have to buy it from Microsoft as a separate product. In addition to the
threads viewer, the Windows Resource Kit has other cool tools, too, such as
tail.exe
, which is similar in functionality
to the
tail
command in Unix. You can also find tools to view threads from third parties on the Internet.
We searched the Internet and downloaded a tool called Process Viewer for Windows from
www.teamcti.com/
pview/prcview.htm
.
Using Process Viewer, you can see the Windows processes, as shown in Figure
21-3
. This is
pretty similar to what you would expect to see in the Task Manager that comes with Windows. Note the process called
ORACLE.EXE. This is the single Oracle process, and all the server processes inside an Oracle instance run within this
process as threads.
Figure 21-3.
Process Viewer for Windows main screen
To find out the threads, right-click the process ORACLE.EXE to open the menu shown in Figure
21-4
.
