SMC_NAME_DATA_CACHE_LARGE_IO_REQUESTED

Description

Reports the number of times the optimizer made requests (of the Adaptive Server buffer manager) to load data into a buffer in this data cache by fetching more than one contiguous page from disk at a time.

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

LONG

LONG

DOUBLE

DOUBLE