Blocking Locks Page
The Blocking Locks page shows a lock tree of sessions that are blocked (waiting for lock requests), and the processes that are blocking them. At the root of the lock tree are the processes that hold locks, but are not waiting for locks. Processes that are waiting for locks are shown underneath the blocking processes.
To open the Blocking Locks page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click Activity | Blocking Locks.
Actions on the Blocking Locks Grid
| Action | Description | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Select (Highlight) a session |
Open the Top Sessions | Session Details Page for the selected session. | ||||||||||||
| Kill a session |
Right-click the session and select Kill Session | …
A message appears that contains the session identifier and serial number of the session to be killed, and the number of rollback segment blocks used. Click Yes to kill the session. Note: Not all users have permission to kill sessions. This permission is granted by the Database Administrator. It is set when the user is created using the Oracle User Wizard. | ||||||||||||
| Trace a session |
Collect performance statistics and diagnostic data for the session. To Trace a session Right-click the session and select Trace a Session | ...
The details of the selected session are now shown in a "highlight" color (red by default). For more information see your Database Administrator. To end a trace session Right-click the session and select End Trace Session The details of the session are now displayed in the "normal" color (black by default). For more information see your Database Administrator. | ||||||||||||
|
View the details of a lock. |
To view details Right click the session and select Show Lock Tip: For information about minimizing locks, see Reduce Lock Contention. |
Grid: Blocking Locks
| Column | Description |
|---|---|
|
SID |
Session Identifier. |
|
Serial # |
Session Serial Number. |
|
User name |
Oracle account name of the session. |
|
PID |
Process Identifier. |
|
Lock type |
Type of lock requested by user. |
|
Mode wanted |
Mode of the lock requested |
|
Object wanted |
The object on which the lock is requested. |