Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

locklists

The locklists table contains individual locklist statistics.  Each active user/transaction has two locklists which are used to manage lock requests issued by the owner transaction.  This table returns one row for each locklist in the current installation.  The delta columns represent changes in counter values in the last interval.

 
Attribute Name Key Datatype Description
timestamp 0 date Date and time the data was collected
vnode 1 varchar(64) Ingres virtual node name
delta_seconds 0 integer4 Elapsed time (seconds) since the previous refresh.
locklist_id 2 integer4 Internal numeric locklist identifier
related_list_id 0 integer4 Internal identifier of the related lock list, each session has two locklists
waiting_lock_id_id 0 integer4 Internal identifier of the lock this locklist is waiting on, the blocking lock
max_locks 0 integer4 Maximum number of locks allowed by this locklists, the transaction lock limit
lock_count 0 integer4 Number of locks currently on the list
lock_count_d 0 integer4 Number of locks acquired in the last interval
logical_count 0 integer4 Number of logical locks on the list
logical_count_d 0 integer4 Number of logical locks acquired int the last interval
server_pid 0 integer4 Operating system process id of the server
session_id 0 varchar(32) Internal identifier of the database server session
connected_locklists 0 integer4 Count of locklists connected to the current locklist.
evflags 0 integer4 Wait event flags.
ev_stamp 0 integer4 Lock wait queue sequence stamp.
name0 0 integer4 Low order part of locklist identifier.
name1 0 integer4 High order part of locklist identifier.
related_count 0 integer4 Count of related locklists.
related_count_d 0 integer4 Change in related locklist count in the last interval.
related_llb 0 integer4 Identifier of the related locklist.
search_count 0 integer4 Most recent deadlock search performed on the locklist.
search_count_d 0 integer4 Change in count of deadlock searches performed in the last interval.
stamp 0 integer4 Current lock request stamp.
status_s 0 varchar(64) Locklist status.
status 0 integer4 Numeric locklist status.
tick 0 integer4 Current clock tick at start of global deadlock search.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.