Note: Available for Oracle 10g and later.
To open the Current Users page
Click Activity | Waiting Events Page | Current Users.
 
Grid: Who is waiting on the event now
This table contains data only when a wait category (and, optionally, a wait event) is selected in the drop-down list at the top of the page.
| Column | Description | 
|---|---|
| 
 SID  | 
 User session ID. 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