|
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 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 |