Blocked sessions
When a session must wait to acquire a lock, it is a waiter. The other session that already has the lock (and is causing the waiter to wait) is a blocker.
This collection contains rows for both the blocker sessions and the waiter sessions in the database. If the row is a blocker session, then BLKBY = 0. If the row is a waiter session, then the BLKBY column has information about its immediate blocker.
Waiters being blocked by a blocker can themselves also block other waiters, potentially forming a blocktree involving many sessions. Thus, a row can be a waiter and a blocker, in some cases (and can involve different locks).
None
| Name | Data Type | Description |
|---|---|---|
| SID | long | Session ID |
| SERIAL# | long | Session serial # |
| SQL_ID | string(16) | SQL ID |
| BLKBY | long | Blocker session ID (SID); 0 = the row is a blocker session |
| BLKCNT | long | Number of sessions being blocked, if the row is a blocker session |
| SESSION_USER | string(32) | Login name |
| Attributes: | None |
|---|---|
| Minimum database version: | 8.1 |