Oracle Server Manager User's Guide

The Session Monitor

The Session Monitor displays information about users' sessions.

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

Figure 11 - 10. Session Monitor

The Session Monitor is described below:

Session ID Identifier for the session.
Serial Number Session serial number, used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session identifier.
Process ID Oracle identifier for the process that owns the session.
Status Status of the session: ACTIVE, INACTIVE, KILLED.
Username Oracle user associated with the session.
Lockwait Address of the lock the session is waiting for, or null if not waiting for a lock.
Current Statement Command currently executing.

Filters

The following filter is available in the Session Monitor:

Username Filter for the user associated with the session. Monitor displays information for sessions whose users match the Username filter.

SQL Worksheet Equivalent

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

	MONITOR SESSION

Required Views

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

V$PROCESS

V$SESSION

Session ID	Identifier for the session.
Serial Number	Session serial number, used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session identifier.
Process ID	Oracle identifier for the process that owns the session.
Status	Status of the session: ACTIVE, INACTIVE, KILLED.
Username	Oracle user associated with the session.
Lockwait	Address of the lock the session is waiting for, or null if not waiting for a lock.
Current Statement	Command currently executing.