The Session Locks page shows the status of open locks, locks that are pending, and objects currently accessed by the session.
To open the Session Locks page
Select the Spotlight on Oracle connection in the Spotlight Browser.
Click Top Sessions Page.
Note: Alternatively, you can view session locks for top sessions by I/O Time on the IO Drilldown | Session Locks Page.
Grids on the Session Locks Page
Held and waiting locks. The columns in this grid are:
|Objects accessed||Objects that are currently accessed by the session. This includes stored programs as well as segments.|