Lock List Display Fields
The Lock List Display has the following columns:
ID
Internal lock list identifier.
Session
The name of the session or <none>. Only lock lists belonging to user transactions have session names.
Count
The total number of locks on the list currently.
Logical
The number of logical locks on the list currently.
MaxL
The total number of logical locks allowed on this list. For user transactions, this is the maximum number of locks per lock list. Some internal lock lists that contain physical locks exceed this number.
Status
State of the lock list when the locking information was obtained. Values include:
EDONE
Event that the lock list is waiting on is done.
ESET
Lock list set on wait queue for event.
EWAIT
Waiting on a system event.
MASTER
Lock list owned by the recovery process.
NOINT
Lock requests on this list are non-interruptible.
NONPROT
Can be released without going through recovery (system lock lists only).
ORPHAN
Lock list remaining without transaction.
RECOVER
Lock list taken over by the recovery process.
SHARED
Lock list is shared. Sessions other than the session that created the lock list may connect to the lock list and make lock calls on it. This is typically for a Master-Slave relationship where a session (Master) creates factotum threads (Slave) to help in the execution of a query (for example a query involving a parallel sort).
WAIT
Waiting for a lock. This indicates a blocked lock. Use the Block_Info menu item to find the blocking lock.
Last modified date: 08/14/2024