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$CIRCUIT

Synopsis

The V$CIRCUIT view returns one row for each session connected using MTS. Table 7.1 describes the columns in the view.

Table G-1. V$CIRCUIT Column Descriptions

Column Name

Description

CIRCUIT

The address of the circuit.

DISPATCHER

The address of the dispatcher process. This matches a value in the PADDR column of the V$DISPATCHER view.

SERVER

The address of the shared server process currently associated with the circuit. This matches a value in the PADDR column of the V$SHARED_SERVER view.

WAITER

The address of the shared server process, if there is one, that is waiting for this circuit to become available.

SADDR

The address of the session connected through this circuit. This matches a value in the SADDR column of the V$SESSION view.

BYTES

A count of the bytes that have passed through this circuit.

BREAKS

The number of times that this circuit has been interrupted.

PRESENTATION

The presentation protocol being used over this circuit. A value of TTC indicates a normal Net8 connection.

STATUS

The status of the circuit. Valid status values are as follows:

BREAK

The circuit has been interrupted by a break.

EOF

The session has disconnected, and the circuit is being removed.

NORMAL

The circuit represents a normal inbound connection to the database.

OUTBOUND

The circuit represents an outbound connection to a remote database.

QUEUE

The queue on which the circuit is sitting. Possible values are:

COMMON

A request has been placed on the common queue and is awaiting ...

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