SMC_NAME_BLOCKING_SPID

Description

Reports the identification number of the process that holds a lock that the process indicated by the SMC_NAME_SPID data item is waiting for. If a process is not blocked, the Blocking SPID is zero.

Version Compatibility

11.0 and later

Data item type

Result

Server level

No

Required keys

SMC_NAME_SPID, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_LOCK_STATUS

Optional keys

SMC_NAME_LOCK_TYPE, SMC_NAME_PAGE_NUM

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

LONG