Chat now with support
Chat with Support

Spotlight on Oracle 10.6 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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

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

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating