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 |