Lock Monitoring

Click the [Realtime] > [Lock Monitoring] menu in the global navigation bar to open the Lock Monitoring screen.

The Lock Monitoring screen displays lock information between sessions in a tree format. Therefore, the users can monitor the Holder Session that is currently holding the lock and the Waiter Session that is waiting to acquire the lock. Additionally, the users can monitor the session holding the lock and terminate a specific session.

The following is a description of the items provided in the Lock Tree Table screen.

Item	Description
Instance	The name of the instance registered in the SysMaster DB
SID	The SID of the session
Serial	The serial number of the session
Elapsed Time	Running time of the session
Status	Session holder and waiter information
Session Status	Session status
Session	Session user name
Module	Session module name
Program	Session program name
Machine	Host name of the session
IP	User IP address of the connection
SQL ID	SQL ID of the SQL being executed by the session
Child Number	Child Number value of the SQL Plan being executed by the session
Wait Event	The name of the wait event for the session
Type	Lock type
ID1	Lock ID1
ID2	Lock ID2
Mode	Lock mode occupied by the holder (Waiter is always 0)
Request	Lock mode requested by the Waiter (Holder is always 0)
Wait Time	Time waited

Kill Session

This feature allows the users to terminate the session holding the lock and release the lock.

First, select the session to be released in the Lock Tree Table, then click the [Kill Session] button in the upper-right corner of the Lock Tree Table screen. This will open the Kill Session pop-up window, where the users can kill the session to release the lock.

Note

This feature is available only to users who have been granted the [Kill Session] permission for the selected instance in Configurable Privileges. For information about pop-up windows, refer to 'Kill Session' in Session Monitoring.