The dynamic mlocks table provides statistical information on locks for each server instance.
Table Columns
|
Name |
Type |
Description |
|
instance_id |
INTEGER |
Server instance. References sysinstances (id) |
|
deadlock_sec |
INTEGER |
Current rate of deadlocks per second |
|
grant_locks |
INTEGER |
Current number of allocated and granted locks |
|
lock_sec |
INTEGER |
Current rate of locks granted per second |
|
block_tran |
INTEGER |
Current number of blocked transactions |
Related