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.
11.0 and later
Result
No
SMC_NAME_SPID, SMC_NAME_DB_ID, SMC_NAME_OBJ_ID, SMC_NAME_LOCK_STATUS
SMC_NAME_LOCK_TYPE, SMC_NAME_PAGE_NUM
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
LONG |
