SMC_NAME_LOCKS_GRANTED_IMMED

Description

Reports the number of locks that were granted immediately, without having to wait for another lock to be released.

Version compatibility

11.5 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_CUR_STMT_ACT_STP_DB_ID + SMC_NAME_CUR_STMT_ACT_STP_ID], [SMC_NAME_ACT_STP_DB_ID + SMC_NAME_ACT_STP_ID]

NoteSMC_NAME_SPID and SMC_NAME_APPLICATION_NAME are mutually exclusive. If you use the SMC_NAME_CUR_STMT_ACT_STP_DB_ID + SMC_NAME_CUR_STMT_ACT_STP_ID key combination, you cannot use any other keys.

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG

LONG

DOUBLE

DOUBLE