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


V$SHARED_SERVER

This view contains information on the shared server processes.

Column  Datatype  Description 

NAME 

VARCHAR2 

Name of the server 

PADDR 

RAW(4) 

Server's process address 

STATUS 

VARCHAR2 

Server status:

EXEC (executing SQL)

WAIT (ENQ) (waiting for a lock),

WAIT (SEND) (waiting to send data to user)

WAIT (COMMON) (idle; waiting for a user request)

WAIT (RESET) (waiting for a circuit to reset after a break)

QUIT (terminating) 

MESSAGES 

NUMBER 

Number of messages processed 

BYTES 

NUMBER 

Total number of bytes in all messages 

BREAKS 

NUMBER 

Number of breaks 

CIRCUIT 

RAW(4) 

Address of circuit currently being serviced 

IDLE 

NUMBER 

Total idle time in hundredths of a second 

BUSY 

NUMBER 

Total busy time in hundredths of a second 

REQUESTS  

NUMBER 

Total number of requests taken from the common queue in this server's lifetime 


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