Chat now with support
Chat with Support

We are currently experiencing issues on our phone support and are working diligently to restore services. For support, please sign in and create a case or email for assistance

Spotlight on Oracle 10.4 - Release Notes

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

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. 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


User session ID.


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


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating