SMC_NAME_PAGE_LOGICAL_READ

Description

Reports the number of data page reads, whether satisfied from cache or from a database device.

Version compatibility

11.0 and later

Data item type

Result

Server level

Yes

Required keys

None

Optional keys

SMC_NAME_SPID, SMC_NAME_APPLICATION_NAME, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_ENGINE_NUM, [SMC_NAME_ACT_STP_DB_ID + SMC_NAME_ACT_STP_ID]

NoteSMC_NAME_SPID and SMC_NAME_APPLICATION_NAME are mutually exclusive.

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG

LONG

DOUBLE

DOUBLE