Database Management Technology 
The locking_stats table contains locking system statistics for a specific Ingres installation (vnode). One row is returned for each vnode in the IMA management domain.
| Attribute Name | Key | Datatype | Description |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| locklists_used | 0 | integer4 | Count of lock lists in use. |
| resources_used | 0 | integer4 | Count of resource blocks in use. |
| locks_used | 0 | integer4 | Count of outstanding lock requests. |
| list_creates | 0 | integer4 | Count of lock list create operations. |
| list_releases | 0 | integer4 | Count of lock list release operations. |
| lock_requests | 0 | integer4 | Count of new lock requests. |
| lock_re_reqs | 0 | integer4 | Number of lock requests with implied conversions. |
| lock_converts | 0 | integer4 | Count of explicit lock conversion requests. |
| lock_releases | 0 | integer4 | Count of physical lock release requests. |
| lock_cancel | 0 | integer4 | Count of lock request timeout cancels. |
| lock_escalates | 0 | integer4 | Count of lock requests resulting in escalations. |
| lock_waits | 0 | integer4 | Count of lock requests forced to wait. |
| lock_searches | 0 | integer4 | Count of deadlock searches performed. |
| lock_deadlocks | 0 | integer4 | Count of lock requests resulting in deadlocks. |
| conv_waits | 0 | integer4 | Count of lock waits caused by lock conversions. |
| conv_searches | 0 | integer4 | Count of deadlock searches initiated by lock conversion waits. |
| conv_deadlocks | 0 | integer4 | Count of lock conversion requests resulting in deadlocks. |
| res_long_chain_len | 0 | integer4 | Maximum resource overflow chain length. |
| lock_long_chain_len | 0 | integer4 | Maximum lock overflow chain length. |
| block_allocs | 0 | integer4 | Count of allocate block operations. |
| block_deallocs | 0 | integer4 | Count of deallocate block calls. |
| lbk_highwater | 0 | integer4 | Highwater mark for LBK blocks in use. |
| lkb_highwater | 0 | integer4 | Highwater mark for locks in use. |
| llb_highwater | 0 | integer4 | Highwater mark for locklists in use. |
| max_lcl_dlk_srch | 0 | integer4 | Maximum length of a deadlock search. |
| rbk_highwater | 0 | integer4 | Highwater mark for RBK blocks in use. |
| rsb_highwater | 0 | integer4 | Highwater mark for resource blocks in use. |
| sbk_highwater | 0 | integer4 | Highwater mark for SBK blocks in use. |
