Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$DISPATCHER

This view provides information on the dispatcher processes.

Column Datatype Description

NAME

VARCHAR2(4)

Name of the dispatcher process

NETWORK

VARCHAR2(128)

Network address of the dispatcher

PADDR

RAW(4 | 8)

Process address

STATUS

VARCHAR2(16)

Status of the dispatcher:

  • WAIT - Idle
  • SEND - Sending a message
  • RECEIVE - Receiving a message
  • CONNECT - Establishing a connection
  • DISCONNECT - Handling a disconnect request
  • BREAK - Handling a break
  • TERMINATE - In the process of terminating
  • ACCEPT - Accepting connections (no further information available)
  • REFUSE - Rejecting connections (no further information available)

ACCEPT

VARCHAR2(3)

Indicates whether this dispatcher is accepting new connections (YES) or not (NO)

MESSAGES

NUMBER

Number of messages processed by the dispatcher

BYTES

NUMBER

Size (in bytes) of messages processed by the dispatcher

BREAKS

NUMBER

Number of breaks occurring in the connection

OWNED

NUMBER

Number of circuits owned by the dispatcher

CREATED

NUMBER

Number of circuits created by the dispatcher

IDLE

NUMBER

Total idle time for the dispatcher (in hundredths of a second)

BUSY

NUMBER

Total busy time for the dispatcher (in hundredths of a second)

LISTENER

NUMBER

Most recent Oracle error number the dispatcher received from the listener

CONF_INDX

NUMBER

Zero-based index of the DISPATCHERS configuration used by the dispatcher