Skip to Main Content
Oracle Net8 Configuration and Troubleshooting
book

Oracle Net8 Configuration and Troubleshooting

by Hugo Toledo, Jonathan Gennick
December 2000
Intermediate to advanced content levelIntermediate to advanced
408 pages
12h 26m
English
O'Reilly Media, Inc.
Content preview from Oracle Net8 Configuration and Troubleshooting

Name

V$DISPATCHER

Synopsis

The V$DISPATCHER view returns one row for each of the instance’s currently running dispatcher processes. Table 7.2 describes the columns in this view.

Table G-2. V$DISPATCHER Column Descriptions

Column Name

Description

NAME

The name of dispatcher, which is D000, D001, D002, and so forth. This dispatcher name forms part of the operating system’s name for the dispatcher process.

NETWORK

The network address on which the dispatcher communicates. This is in the standard Net8 format. For example:

(ADDRESS=(PROTOCOL=tcp)
         (HOST=donna.gennick.org)
         (PORT=1189))

PADDR

The dispatcher’s process address.

STATUS

The current status of the dispatcher. This is one of the following values:

BREAK

The dispatcher is currently handling an interrupt.

CONNECT

The dispatcher is establishing a new inbound connection to the database.

DISCONNECT

The dispatcher is disconnecting a session.

OUTBOUND

The dispatcher is establishing an outbound connection to a remote database.

RECEIVE

The dispatcher is receiving a message.

SEND

The dispatcher is sending a message.

ACCEPT

Indicates whether or not the dispatcher is accepting new connections. ACCEPT returns either a YES or a NO value.

MESSAGES

A count of the messages that have been processed by the dispatcher.

BYTES

The total number of bytes in all the messages processed by the dispatcher.

BREAKS

The total number of breaks handled by the dispatcher.

OWNED

The number of circuits currently associated with this dispatcher. A circuit usually ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux

Steve Shaw, Martin Bach
Oracle 11g

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 1565927532Catalog PageErrata