SMC_NAME_LOCKS_GRANTED_WAITED

Description

Reports the number of locks that were granted after waiting 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]

SMC_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