Snapshot Level Application Lock |
Logical Data Grouping appl appl_lock lock_wait |
Monitor Switch Lock Lock Lock |
Resettable |
No |
|
Event Type Deadlock |
Logical Data Grouping dlconn_event |
|
Element Name Element Type |
appl_id_holding_lk information |
Description: The application ID of the application that is holding a lock on the object that this application is waiting to obtain.
Usage: This element can help you determine which applications are in contention for resources. Specifically, it can help you identify the application handle (agent ID) and table ID that are holding the lock. Note that you may use the LIST APPLICATIONS command to obtain information to relate the application ID with an agent ID. However, it is a good idea to collect this type of information when you take the snapshot, as it could be unavailable if the application ends before you run the LIST APPLICATIONS command.
Note that more than one application can hold a shared lock on an object for which this application is waiting to obtain a lock. See Lock Mode for information about the type of lock that the application holds. If you are taking an application snapshot, only one of the application IDs holding a lock on the object will be returned. If you are taking a lock snapshot, all of the application IDs holding a lock on the object will be returned.