Lock Escalation



Snapshot Level
Lock


Logical Data Grouping
lock
lock_wait


Monitor Switch
Lock
Lock


Resettable


No


 


Event Type
Deadlock


Logical Data Grouping
dlconn_event


 


Element Name
Element Type



lock_escalation
information

Description:  Indicates whether a lock request was made as part of a lock escalation.

Usage:  Use this element to better understand the cause of deadlocks. If you experience a deadlock that involves applications doing lock escalation, you may want to increase the amount of lock memory or change the percentage of locks that any one application can request.