Monitoring Database Locks |
You can monitor details of the locks used in the database. This information includes the lock table, lock granularity, lock status, and lock modes for all data objects.
The table summarizes the items on the lock page:
|
Item |
Description |
|
Object Name: |
The object name for a locked object, or an object that a lock is requested for. |
|
Level: |
The current lock level. Four lock levels exist for an object: System, Table, Page, and Row. |
|
Object ID |
A identifying number unique to each table, page, or row in the database. |
|
Login Name |
Name of the user that has the lock on the object. |
|
Connection ID: |
The ID of the session |
|
Lock Mode: |
The current lock mode of an object. The shown lock modes are either S, IS, IX, X and SIX. IS, SIX, and IX denote that the object has an intention lock; part of the lock on the object is specified at a lower granularity. |
|
Waiting Mode: |
The lock mode that the user is requesting. It can be "none", indicating that the user does not desire a new lock on the object, or "S", "IS", "IX", "X" or "SIX", indicating that the user has requested the corresponding lock type on the object and is waiting for the lock. |
|
Status: |
Status indicates the condition of the Waiting Mode. "Granted" indicates that the user has been granted the requested lock and should correspond to a waiting mode of "none". "Waiting" indicates that the user has not yet been granted the requested object lock and should correspond to a Waiting mode of "S", "IS", "IX", "X" or "SIX". "Convert" indicates that the user has requested a change in lock level (for example, from "S" to "X") and the user is waiting for the new lock level on the object. |
Table: Database Lock items
Related topic:
Database
Monitor (Tree)
Viewing Lock Status
Waiting Information