Database Management Technology

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

wait_locklists

The wait_locklists table is the collection of locklists currently in a lock wait state.  This table simplifies the process of detecting and identifying users waiting on lock requests.

 
Attribute Name Key Datatype Description
timestamp 0 date Date and time the data was collected
vnode 1 varchar(64) Ingres virtual node name
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_wait_locklists 0 integer4 Count of waiting locklists.
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 count of related locklists in the last interval.
related_llb 0 integer4 Internal identifier of the related locklist.
search_count 0 integer4 Most recent deadlock search performed on the locklists.
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) Current 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.