Event Type Transaction |
Logical Data Grouping xaction_event |
|
Element Name Element Type |
locks_held_top counter |
Description: The maximum number of locks held during this transaction.
Usage: You can use this element to determine if your application is approaching the maximum number of locks available to it, as defined by the maxlocks configuration parameter. This parameter indicates the percentage of the lock list that each application can use before lock escalations occur. Lock escalations can result in a decrease in concurrency between applications connected to a database. (See the Administration Guide for more information about this parameter.)
Since the maxlocks parameter is specified as a percentage and this element is a counter, you can compare the count provided by this element against the total number of locks that can be held by an application, as calculated using the following formula:
(locklist * 4096 / 36 ) * (maxlocks / 100)
If you have a large number of locks, you may need to perform more commits within your application so that some of the locks can be released.