V$CACHE_FUSION_HISTOGRAM

V$CACHE_FUSION_HISTOGRAM displays a breakdown of various processing latencies in the Global Cache Service processes (LMS) used in cache fusion.

This view is a superset of the V$CURRENT_BLOCK_SERVER view, which reports just pin and flush statistics.

Column Datatype Description
STATISTIC_NAME VARCHAR2(34) Name of the statistic
TOTAL NUMBER Total histogram count for the statistic
BKT10US NUMBER Histogram count for values taking less than 10 microseconds
BKT100US NUMBER Histogram count for values taking 10 to 100 microseconds
BKT1MS NUMBER Histogram count for values taking 100 microseconds to 1 millisecond
BKT10MS NUMBER Histogram count for values taking 1 to 10 milliseconds
BKT100MS NUMBER Histogram count for values taking 10 to 100 milliseconds
BKT1S NUMBER Histogram count for values taking 100 milliseconds to 1 second
BKT10S NUMBER Histogram count for values taking 1 to 10 seconds
BKTOVERFLOW NUMBER Histogram count for values taking more than 10 seconds
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.8.

See Also: “V$CURRENT_BLOCK_SERVER”