This view shows information about the performance of individual data caches.
For each named cache, including the default data cache, configured in Adaptive Server, this view collects the cache’s name and the percentage of page reads for objects bound to the cache that were satisfied from the cache since the start of the recording session.
This view also shows the:
Efficiency of the cache’s use of space
Percentage of times when an attempt to acquire the cache’s spinlock was forced to wait, since the start of the session
Number of cache hits and misses for the session
SMC_SIZET data_cache_activity_count = 7;
SMC_DATAITEM_STRUCT data_cache_activity__view[] = {
{ SMC_NAME_DATA_CACHE_NAME, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_DATA_CACHE_ID, SMC_STAT_VALUE_SAMPLE },
{ SMC_NAME_DATA_CACHE_HIT_PCT, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_DATA_CACHE_EFFICIENCY, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_DATA_CACHE_CONTENTION, SMC_STAT_RATE_SESSION },
{ SMC_NAME_DATA_CACHE_HIT, SMC_STAT_VALUE_SESSION },
{ SMC_NAME_DATA_CACHE_MISS, SMC_STAT_RATE_SESSION }
};
