5.429 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 less than 1 second

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"