How to view the current locks (Enterprise Manager)

To view the current locks

Expand a server group, and then expand a server.
Expand Management, and then expand Current Activity.
Do one of the following:
- Expand Locks / Process ID to view the current locks for each connection.
- Expand Locks / Object to view the current locks for each object.
In the console tree, click the connection (SPID) or object to view.
The current locks for the connection or object are displayed in the details pane.