See Also
You are here: System database > mlocks
ContentsIndexHome
PreviousUpNext
mlocks
System Table mlocks

 

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