SMC_NAME_DATA_CACHE_ID

Description

Reports the ID of a data cache. Tables or indexes or both can be bound to a specific data cache, or all objects in a database can be bound to the same data cache. No object can be bound to more than one data cache.

Version compatibility

11.0 and later

Data item type

Key

Server level

Result data items that require this key

SMC_NAME_DATA_CACHE_CONTENTION

SMC_NAME_DATA CACHE_EFFICIENCY

SMC_NAME_DATA_CACHE_HIT

SMC_NAME_DATA_CACHE_HIT_PCT

SMC_NAME_DATA_CACHE_LARGE_IO_DENIED

SMC_NAME_DATA_CACHE_LARGE_IO_PERFORMED

SMC_NAME_DATA_CACHE_LARGE_IO_REQUESTED

SMC_NAME_DATA_CACHE_MISS

SMC_NAME_DATA_CACHE_NAME

SMC_NAME_DATA_CACHE_PREFETCH_EFFICIENCY

SMC_NAME_DATA_CACHE_REF_AND_REUSE

SMC_NAME_DATA_CACHE_REUSE

SMC_NAME_DATA_CACHE_SIZE

Result data items for which this key is optional

SMC_NAME_DATA_CACHE_REUSE_DIRTY

Statistic types and datatypes

VALUE_ SAMPLE	VALUE_ SESSION	RATE_ SAMPLE	RATE_ SESSION	AVG_ SAMPLE	AVG_ SESSION
LONG