Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

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

Dynamic Performance (V$) Views, 50 of 237


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 DISPATCHERS configuration used by this dispatcher


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

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback