Lock tree

Home > Select Project > Analysis > Lock Tree

You can analyze the trend of locks during the day. The session that caused a lock (Lock Holder) and the session waiting for a lock (Lock Waiter) can be checked through a tree structure. Through these functions, you can analyze queries by checking the relationship between holders and waiters for locks that occurred at specific points.

Basic screen guide

Set the desired date and time, and then select an instance from the list. If a lock occurs at the set time, lock wait sessions and the retrieved data appear in the table at the bottom of the screen.

Column information guide

Item	Description
tranindex	Transaction index
user	Database user name
host	Host name of CAS that performs transactions
pid	Broker process ID
program	Client program name
query_time	Total execution time of active queries (unit: second)
tran_time	Total execution time of transactions (unit: second)
transtatus	Transaction status
lock_holder	List of transactions that own a lock if transactions are waiting for the lock
sql_id	ID for SQL text
sql_text	Query statement being executed (up to 30 characters)
sql_param	Literal value separated from query
sql_hash	Hash value of query (internal WhaTap control value)