The Blocked By tab displays details about other queries that are blocking this query. This information is read-only. The tab is available as long as other queries continue to block this query. When the blocking query conditions are resolved, this query can then complete, and the tab is no longer displayed.
Blocked By Information | Description |
---|---|
Username | Name of the user that is running the query that holds the lock |
Session ID | Session ID of the blocking query |
Lock Type | Type of lock. Type can be Exclusive, Read, Write, or Access. |
Locked | Name of the locked object |