These columns identify the number of lock requests, blocks, and deadlocks on a disk segment, including those implied for segment acquires.
The locks referred to here are short term file system locks and are distinct from transaction locks, which are counted in the fields documented in General Concurrency Control Database Locks Columns.
Column Name | Mode | Description | Data Type |
---|---|---|---|
FileLockBlocks | count | Number of lock requests that were blocked. This column is calculated as follows: Total locks - Locks blocked = Locks with immediate grants |
FLOAT |
FileLockDeadlocks | count | Number of deadlocks detected on lock requests. | FLOAT |
FileLockEnters | count | Number of lock requests on disk segments. | FLOAT |