Chat now with support
Chat with Support

Spotlight on Oracle 10.7 - Release Notes

Current Users Page

Note: Available for Oracle 10g and later.

View current users for waiting events in the cluster coordination category.

To open the Current Users page

  1. Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
  2. Click Cluster | Overhead Page | Current Users.

Note: Click ActivityWaiting Events Page to show wait events in other categories.

Grid: Who is waiting on the event now

Column Description

SID

User session ID.

Tip: Double click a session. This opens the Top Sessions | Session Details Page.

Tip: Double click a session. This opens the Top Sessions | Session Details Page.

User

User name for a session.

Wait State/Time

The wait status and how long the session has waited in its last wait.

Waiting Location

The details of the wait.

Sequence

Sequence number of the wait.

Serial #

Serial number for the specified session.

Service Name  

Note: Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating