8.121 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 Database 23ai, Release Update 23.8.

See Also:

"V$CURRENT_BLOCK_SERVER"