DBA_HIST_SHARED_SERVER_SUMMARY
displays historical information for shared servers. This includes information about shared server activity, the servers, common queues, and dispatcher queues. This view obtains information from V$SHARED_SERVER
, V$DISPATCHER
, V$CIRCUIT
, and V$QUEUE
, and is aggregated over all servers, dispatchers, queues, and circuits.
Column  Datatype  NULL  Description 

SNAP_ID 
NUMBER 
NOT NULL 
Unique snapshot ID 
DBID 
NUMBER 
NOT NULL 
Database ID for the snapshot 
INSTANCE_NUMBER 
NUMBER 
NOT NULL 
Instance number for the snapshot 
NUM_SAMPLES 
NUMBER 
Total number of samples  
SAMPLE_TIME 
NUMBER 
Last sample timestamp  
SAMPLED_TOTAL_CONN 
NUMBER 
Cumulative sum of total number of connections over all samples. To determine the average number of connections between two snapshots, divide the difference in SAMPLED_TOTAL_CONN by the difference in NUM_SAMPLES . 

SAMPLED_ACTIVE_CONN 
NUMBER 
Cumulative sum of active number of connections over all samples. To determine the average number of active connections between two snapshots, divide the difference in SAMPLED_ACTIVE_CONN by the difference in NUM_SAMPLES . 

SAMPLED_TOTAL_SRV 
NUMBER 
Cumulative sum of total number of servers over all samples. To determine the average number of servers between two snapshots, divide the difference in SAMPLED_TOTAL_SRV by the difference in NUM_SAMPLES . 

SAMPLED_ACTIVE_SRV 
NUMBER 
Cumulative sum of active number of servers over all samples. To determine the average number of active servers between two snapshots, divide the difference in SAMPLED_ACTIVE_SRV by the difference in NUM_SAMPLES . 

SAMPLED_TOTAL_DISP 
NUMBER 
Cumulative sum of total number of dispatchers over all samples. To determine the average number of dispatchers between two snapshots, divide the difference in SAMPLED_TOTAL_DISP by the difference in NUM_SAMPLES . 

SAMPLED_ACTIVE_DISP 
NUMBER 
Cumulative sum of active number of dispatchers over all samples. To determine the average number of active dispatchers between two snapshots, divide the difference in SAMPLED_ACTIVE_DISP by the difference in NUM_SAMPLES . 

SRV_BUSY 
NUMBER 
Total shared server busy time (in hundredths of a second)  
SRV_IDLE 
NUMBER 
Total shared server idle time (in hundredths of a second)  
SRV_IN_NET 
NUMBER 
Total shared server incoming network wait time (in hundredths of a second). This includes waits for receives and resets. This time is also included in SRV_BUSY . 

SRV_OUT_NET 
NUMBER 
Total shared server outgoing network wait time (in hundredths of a second). This includes waits for sends and outbound connection requests. This time is also included in SRV_BUSY . 

SRV_MESSAGES 
NUMBER 
Number of messages processed  
SRV_BYTES 
NUMBER 
Total number of bytes in all messages  
CQ_WAIT 
NUMBER 
Total time that all items in the common queue have waited (in hundredths of a second)  
CQ_TOTALQ 
NUMBER 
Total number of items that have ever been in the common queue  
DQ_TOTALQ 
NUMBER 
Total number of items that have ever been in a dispatcher queue 