Lock Mode

 
Snapshot Level
Application
Lock

 
Logical Data Grouping
appl
lock
lock_wait

 
Monitor Switch
Lock
Lock
Lock

Resettable

No

Event Type
Deadlock

Logical Data Grouping
dlconn_event

Element Name
Element Type

lock_mode
information

Description:  The type of lock being held.

Usage:  This mode can help you determine the source of contention for resources.

This element indicates one of the following, depending on the type of monitor information being examined:

• The type of lock another application holds on the object that this application is waiting to lock (for application-monitoring and deadlock-monitoring levels)
• The type of lock held on the object by this application (for object-lock levels).

The values for this field are:

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	Next Key Share Lock	SQLM_LONS
NX	Next Key Exclusive Lock	SQLM_LONX
W	Weak Exclusive Lock	SQLM_LOOW
NW	Next Key Weak Exclusive Lock	SQLM_LONW