Reports the number of locks being blocked by the process that holds this “hold_and_blocking” lock.
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 |
