SMC_NAME_DATA_CACHE_HIT_PCT

Description

Reports the fraction of the page reads satisfied, which is computed from the following formula:

cache_hits / (cache_hits + cache_misses) * 100

Version compatibility

11.0 and later

Data item type

Result

Server level

No

Required keys

DATA_CACHE_ID

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

DOUBLE

DOUBLE

NoteWhen SMC_NAME_DATA_CACHE_MISS overstates the number of physical page reads, SMC_NAME_DATA_CACHE_HIT_PCT understates the percentage of cache hits.