To
view database lock status:
Select the Lock node from the Database Monitor node in the tree. The following window will appear.

Click Refresh at any time to update the statistics shown on this page. You may also choose what information to display on the Lock page.
Selecting Show System Table allows you to see any locks placed on the system table.
Selecting Show System Level allows the DBA to see locks placed on objects in the system level.
You can choose to view locks only on certain objects. Select an object name from the Object menu.
You can choose to view locks on all objects associated with a user. Select a connection ID from the Connection ID menu.
Related topic: