Locking System Summary Fields
By observing the fields on the Locking System Summary, you can spot conditions when more locking system resources need to be made available. You reconfigure the locking system using rcpconfig. For more information, see the System Administrator Guide.
The Locking System Summary has the following fields:
Lock List Created
The number of times a lock list was created on behalf of a server, session, or transaction.
Lock List Released
The number of times a release of a lock list occurred on behalf of a server, session, or transaction.
Lock Lists in Use
The number of lock lists in use by a server, session, or transaction.
Lock Lists Remaining
The number of lock lists remaining to be used by a server, session, or transaction.
Lock Requested
The number of new lock requests that the locking system processed.
Lock Rerequested
The number of times an implicit lock conversion request was issued on a resource that the lock list already had locked. Implicit lock conversions can occur when a request is made on a page for update that was previously requested for read.
Lock Converted
The number of times an explicit lock conversion request is made to change a lock mode on a physical lock from one mode to another. These types of requests occur as a result of a physical lock being converted during an existing transaction to lower or higher modes.
Lock Released
The number of times a specific logical lock is released, as opposed to a full, partial, or physical lock release.
Lock Cancelled
The number of times a lock request was cancelled due to a timeout or interrupt.
Lock Escalated
The number of times a partial release occurred to allow escalation of lock granularity from page to table level.
Locks in Use
The number of locks in use by a server, session, or transaction.
Locks Remaining
The number of locks remaining to be used by a server, session, or transaction.
Total available
The total sum of resources in use, locks in use, and locks remaining
Deadlock search
The number of times a deadlock search was initiated.
Deadlock
The number of times that deadlock existed.
Convert wait
The number of times an existing lock waited for conversion to a different lock mode.
Convert deadlock
The number of times a request for conversion turned into a deadlock.
Lock Wait
The number of times a new lock request had to wait to be granted.
Last modified date: 08/14/2024