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, 25 of 179


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-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index