SMC_NAME_CUR_STMT_LOCKS_GRANTED_IMMED

Description

Reports the number of lock requests by the currently executing SQL statement that were granted immediately or were not needed (because sufficient locking was already held by the requestor).

Version compatibility

11.5 and later

Data item type

Result

Server level

Required keys

SMC_NAME_SPID

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE	VALUE_ SESSION	RATE_ SAMPLE	RATE_ SESSION	AVG_ SAMPLE	AVG_ SESSION
LONG	LONG	DOUBLE	DOUBLE