Oracle Server Manager User's Guide

The Circuit Monitor

The Circuit Monitor displays information about virtual circuits. A virtual circuit is a connection to an instance through a dispatcher and the shared server currently processing the user's request.

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

Figure 11 - 1. Circuit Monitor

The Circuit Monitor is described below:

Circuit Address of the virtual circuit.
Dispatcher Name Name of the dispatcher associated with the virtual circuit.
Server Name of the shared server currently associated with the virtual circuit.
Session SID Identifier for the session bound to the virtual circuit.
Session Serial # 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.
Status Status of the circuit:
BREAK Currently interrupted.
EOF About to be removed.
OUTBOUND A link to a remote database.
NORMAL Normal circuit into the local database.
Queue Name of the queue the circuit is currently on:
COMMON Waiting for request to be picked up by a server process.
DISPATCHER Waiting for the dispatcher process.
SERVER Waiting for server to finish processing request.
OUTBOUND Waiting to establish an outbound connection.
NONE Idle circuit.
Messages Total number of messages that have gone through the circuit.
Bytes Total number of bytes that have gone through the circuit.

SQL Worksheet Equivalent

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

	MONITOR CIRCUIT

Required Views

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

V$CIRCUIT

V$DISPATCHER

V$SESSION

V$SHARED_SERVER

Circuit	Address of the virtual circuit.
Dispatcher Name	Name of the dispatcher associated with the virtual circuit.
Server	Name of the shared server currently associated with the virtual circuit.
Session SID	Identifier for the session bound to the virtual circuit.
Session Serial #	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.
Status	Status of the circuit:
	BREAK Currently interrupted.
	EOF About to be removed.
	OUTBOUND A link to a remote database.
	NORMAL Normal circuit into the local database.
Queue	Name of the queue the circuit is currently on:
	COMMON Waiting for request to be picked up by a server process.
	DISPATCHER Waiting for the dispatcher process.
	SERVER Waiting for server to finish processing request.
	OUTBOUND Waiting to establish an outbound connection.
	NONE Idle circuit.
Messages	Total number of messages that have gone through the circuit.
Bytes	Total number of bytes that have gone through the circuit.