Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 42 of 179


V$DISPATCHER

This view provides information on the dispatcher processes.

Column  Datatype  Description 

NAME 

VARCHAR2 

Name of the dispatcher process 

NETWORK  

VARCHAR2 

Network address of this dispatcher. 

PADDR 

RAW(4) 

Process address 

STATUS  

VARCHAR2 

The status of the dispatcher (one of the following):

  • 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 

Whether this dispatcher is accepting new connections: YES | NO 

MESSAGES 

NUMBER 

Number of messages processed by this dispatcher 

BYTES 

NUMBER 

Size in bytes of messages processed by this dispatcher 

BREAKS 

NUMBER 

Number of breaks occurring in this connection 

OWNED 

NUMBER 

Number of circuits owned by this dispatcher 

CREATED 

NUMBER 

Number of circuits created by this dispatcher 

IDLE  

NUMBER 

Total idle time for this dispatcher in hundredths of a second 

BUSY  

NUMBER 

Total busy time for this dispatcher in hundredths of a second 

LISTENER 

NUMBER 

The most recent Oracle error number the dispatcher received from the listener 

CONF_INDX 

NUMBER 

Zero-based index of the MTS_DISPATCHERS configuration used by this dispatcher 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index