Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
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, 27 of 211


V$CIRCUIT

This view contains information about virtual circuits, which are user connections to the database through dispatchers and servers.

Column  Datatype  Description 

CIRCUIT 

RAW(4) 

Circuit address 

DISPATCHER 

RAW(4) 

Current dispatcher process address 

SERVER 

RAW(4) 

Current server process address 

WAITER  

RAW(4) 

Address of server process that is waiting for the (currently busy) circuit to become available 

SADDR 

RAW(4) 

Address of session bound to the circuit 

STATUS  

VARCHAR2(16) 

Status of the circuit:

  • BREAK - currently interrupted

  • EOF - about to be removed

  • OUTBOUND - an outward link to a remote database

  • NORMAL - normal circuit into the local database

 

QUEUE  

VARCHAR2(16) 

Queue the circuit is currently on:

  • COMMON - on the common queue, waiting to be picked up by a server process

  • DISPATCHER - waiting for the dispatcher

  • SERVER - currently being serviced

  • NONE - idle circuit

 

MESSAGE0  

NUMBER 

Size in bytes of the messages in the first message buffer 

MESSAGE1  

NUMBER 

Size in bytes of the messages in the second message buffer 

MESSAGE2 

NUMBER 

Size in bytes of the messages in the third message buffer 

MESSAGE3 

NUMBER 

Size in bytes of the messages in the fourth message buffer 

MESSAGES  

NUMBER 

Total number of messages that have gone through this circuit 

BYTES  

NUMBER 

Total number of bytes that have gone through this circuit 

BREAKS  

NUMBER 

Total number of breaks (interruptions) for this circuit 

PRESENTATION 

VARCHAR2(16) 

The presentation protocol used by the client and server 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, 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