Current Users Page
Note: Available for Oracle 10g and later.
To open the Current Users page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
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