V$CLIENT_REQUEST_HISTOGRAM

V$CLIENT_REQUEST_HISTOGRAM displays histogram data about response times for client requests.

Column	Datatype	Description
SERVICE_ID	NUMBER	Service ID
SERVICE_NAME_HASH	NUMBER	Service name hash from V$SERVICES
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_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.