The mode in which the lock was requested
by the application waiting to acquire the lock.
Table 2. Snapshot Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor Switch |
Lock |
lock_wait |
Lock |
Table 3. Event Monitoring InformationEvent Type |
Logical Data Grouping |
Monitor Switch |
Locking |
- |
- |
Deadlocks1 |
event_dlconn |
- |
Deadlocks with Details1 |
event_detailed_dlconn |
- |
- 1
- This option has been deprecated. Its
use is no longer recommended and might be removed in a future release.
Use the CREATE EVENT MONITOR FOR LOCKING statement to monitor lock-related
events, such as lock timeouts, lock waits, and deadlocks.
Usage
The mode in which the lock was requested
by the application. This value can help you determine the source of
contention for resources.
The possible
lock modes are listed in the following table.
Mode |
Type of Lock |
API Constant |
|
No Lock |
SQLM_LNON |
IS |
Intention Share Lock |
SQLM_LOIS |
IX |
Intention Exclusive Lock |
SQLM_LOIX |
S |
Share Lock |
SQLM_LOOS |
SIX |
Share with Intention Exclusive Lock |
SQLM_LSIX |
X |
Exclusive Lock |
SQLM_LOOX |
IN |
Intent None |
SQLM_LOIN |
Z |
Super Exclusive Lock |
SQLM_LOOZ |
U |
Update Lock |
SQLM_LOOU |
NS |
Scan
Share Lock |
SQLM_LONS |
NW |
Next Key Weak Exclusive Lock |
SQLM_LONW |