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 Cluster | Overhead Page | All Users.
Note: Click Activity | Waiting Events Page to show wait events in other categories.
Grid: Who has waited on the event
| 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