DBA_HIST_CLIENT_REQUEST_HISTOGRAM

DBA_HIST_CLIENT_REQUEST_HISTOGRAM displays historical statistics about client request response times.

This view contains snapshots of V$CLIENT_REQUEST_HISTOGRAM.

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
SERVICE_NAME_HASH NUMBER NOT NULL Hash of the service name
SERVICE_NAME VARCHAR2(64) NOT NULL Service ID
BUCKET01_COUNT NUMBER   Number of requests with elapsed time of 1 second or less
BUCKET02_COUNT NUMBER   Number of requests with elapsed time in the range of (1, 5] seconds
BUCKET03_COUNT NUMBER   Number of requests with elapsed time in the range (5, 10] seconds
BUCKET04_COUNT NUMBER   Number of requests with elapsed time in the range (10, 30] seconds
BUCKET05_COUNT NUMBER   Number of requests with elapsed time in the range (30, 60] seconds
BUCKET06_COUNT NUMBER   Number of requests with elapsed time in the range (60, 120] seconds
BUCKET07_COUNT NUMBER   Number of requests with elapsed time in the range (120, 180] seconds
BUCKET08_COUNT NUMBER   Number of requests with elapsed time in the range (180, 300] seconds
BUCKET09_COUNT NUMBER   Number of requests with elapsed time in the range (300, 600] seconds
BUCKET10_COUNT NUMBER   Number of requests with elapsed time in the range (600, 1200] seconds
BUCKET11_COUNT NUMBER   Number of requests with elapsed time in the range (1200, 3600] seconds
BUCKET12_COUNT NUMBER   Number of requests with elapsed time in the range (3600, 7200] seconds
BUCKET13_COUNT NUMBER   Number of requests with elapsed time in the range (7200, 14400] seconds
BUCKET14_COUNT NUMBER   Number of requests with elapsed time greater than 14400 seconds
BUCKET15_COUNT NUMBER   Reserved for future use
BUCKET16_COUNT NUMBER   Reserved for future use
CON_DBID NUMBER   The database ID of the pluggable database (PDB)
CON_ID NUMBER  

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai, Release Update 23.26.3.

See Also: “V$CLIENT_REQUEST_HISTOGRAM”