All Users Page
Note: Available for Oracle 10g and later.
The All Users page contains a single table, Who has waited on the event, which shows the following details for any current user session that has waited (even if it is no longer waiting).
To open the All Users page
- Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
-
Click Activity | Waiting Events Page | All Users.
Grid: Who has waited on the event
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. |
|
User |
User name for a session. |
|
Time waited (ms) |
The total amount of time the session has waited, measured in milliseconds. |
|
Time waited (ms/s) |
he rate at which the session has waited, measured in milliseconds per second. |
|
Total waits |
The total number of waits for the session. |
|
Total waits per second |
The rate at which the session has waited, measured in waits per second. |
|
Total timeout |
The total number of timeouts for the session. |
|
Max wait (ms) |
The maximum time waited, measured in milliseconds. |
|
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