[Home] [Help] [Dependency Information]
Object Name: | CDB_HIST_SHARED_SERVER_SUMMARY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Shared Server summary statistics in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
NUM_SAMPLES | NUMBER | |||
SAMPLE_TIME | NUMBER | |||
SAMPLED_TOTAL_CONN | NUMBER | |||
SAMPLED_ACTIVE_CONN | NUMBER | |||
SAMPLED_TOTAL_SRV | NUMBER | |||
SAMPLED_ACTIVE_SRV | NUMBER | |||
SAMPLED_TOTAL_DISP | NUMBER | |||
SAMPLED_ACTIVE_DISP | NUMBER | |||
SRV_BUSY | NUMBER | |||
SRV_IDLE | NUMBER | |||
SRV_IN_NET | NUMBER | |||
SRV_OUT_NET | NUMBER | |||
SRV_MESSAGES | NUMBER | |||
SRV_BYTES | NUMBER | |||
CQ_WAIT | NUMBER | |||
CQ_TOTALQ | NUMBER | |||
DQ_TOTALQ | NUMBER | |||
CON_DBID | NUMBER | |||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, NUM_SAMPLES
, SAMPLE_TIME
, SAMPLED_TOTAL_CONN
, SAMPLED_ACTIVE_CONN
, SAMPLED_TOTAL_SRV
, SAMPLED_ACTIVE_SRV
, SAMPLED_TOTAL_DISP
, SAMPLED_ACTIVE_DISP
, SRV_BUSY
, SRV_IDLE
, SRV_IN_NET
, SRV_OUT_NET
, SRV_MESSAGES
, SRV_BYTES
, CQ_WAIT
, CQ_TOTALQ
, DQ_TOTALQ
, CON_DBID
, CON_ID
FROM SYS.CDB_HIST_SHARED_SERVER_SUMMARY;
SYS.CDB_HIST_SHARED_SERVER_SUMMARY does not reference any database object
SYS.CDB_HIST_SHARED_SERVER_SUMMARY is referenced by following:
|
|
|