Chat now with support
Chat with Support

Spotlight on Oracle 10.6 - Release Notes

Session Locks Page

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

  1. Select the Spotlight on Oracle RAC connection in the Spotlight Browser.

  2. Click I/O | Sessions Page.

  3. Select a Session in the Top Sessions grid.
  4. Click Session Locks.

Note: Alternatively, you can view Session Details on the Top Sessions | Session Locks Page.

Grids on the Session Locks Page

Grid

Description
Session Locks

Held and waiting locks. The columns in this grid are:

  • Type - The type of lock.
  • Request - Mode in which the lock is requested.
  • Holding - Mode in which the lock is held.
  • Blocking? - Is this lock blocking other users?
  • Object - Object upon which the lock is held.
Objects accessed Objects that are currently accessed by the session. This includes stored programs as well as segments.

 

Related Topics

Spotlight on Oracle RAC Drilldowns

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating