Menu Locks - Online Locks

The tab shows the current occurrences of locks in the monitored database. Information on locks can be refreshed by clicking on [Refresh] button.
Sessions involved in a lock are displayed as a list in the form of a tree, where:

• sessions marked as BLOCKER are the blocking session
• the nodes below are sessions waiting WAITER blocked by sessions in the parent node

A [Kill session] button is available on the screen, which allows you to delete the selected user session. This operation is available only when the DBPLUS user assigned to monitoring has additional permissions. Default permissions do not allow deleting the session. The visibility of the button can be limited by assigning appropriate permissions (Function rights) at the Securityscreen level.

Selecting a session displays the content of the query that the session is currently executing, as well as session details. Information about the query ID is available in the session details. After expanding the dedicated menu with the [+] button, we have the ability to go to the details of a given query View sql details, as well as view the session history for the query View session history.