Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-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
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

V$DISPATCHER

V$DISPATCHER displays information about the dispatcher processes.

Column Datatype Description
NAME VARCHAR2(4) Name of the dispatcher process
NETWORK VARCHAR2(1024) 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 the 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