Oracle Server Manager User's Guide

The Process Monitor

The Process Monitor shows the background and user processes for the instance.

The following figure illustrates the left-most columns of the Process Monitor.

Figure 11 - 7. Process Monitor

The Process Monitor is described below:

Oracle PID Oracle process identifier.
System PID Operating system process identifier.
Username Username associated with the operating system process.
Terminal Operating system terminal, if any.
Latchwait Address of the latch the process is waiting for, or null if not waiting for a latch.
Program Name of the program the process is executing.

Filters

The following filters are available in the Process Monitor:

Min PID Minimum process ID. Monitor displays processes with ID numbers greater than or equal to Min PID.
Max PID Maximum process ID. Monitor displays process with ID numbers less than or equal to Max PID.

SQL Worksheet Equivalent

To start the Process Monitor from a SQL Worksheet, you can use the following Server Manager command:

	MONITOR PROCESS

Required Views

To use the Process Monitor, you must have access to:

V$PROCESS

Oracle PID	Oracle process identifier.
System PID	Operating system process identifier.
Username	Username associated with the operating system process.
Terminal	Operating system terminal, if any.
Latchwait	Address of the latch the process is waiting for, or null if not waiting for a latch.
Program	Name of the program the process is executing.

Min PID	Minimum process ID. Monitor displays processes with ID numbers greater than or equal to Min PID.
Max PID	Maximum process ID. Monitor displays process with ID numbers less than or equal to Max PID.