These columns summarize the number of lock requests, blocks, and deadlocks on a disk segment.
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.
For more information, see “Data Segment Lock Requests Columns” in ResUsageSvpr Table Overview.
Column Name | Mode | Description | Data Type |
---|---|---|---|
FileLockBlocks | count | Number of lock requests that were blocked. | FLOAT |
FileLockDeadlocks | count | Number of deadlocks detected on lock requests. | FLOAT |
FileLockEnters | count | Number of times a lock was requested. | FLOAT |