Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Release Notes

Waits Page

Note: Available for Oracle 10.2 and later.

The Waits page shows service-related wait events for the Oracle RAC cluster.

To open the Waits page

  1. Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
  2. Click Services | Waits.

  3. Select a Service to view event waits for.

The Event Waits Grid

For the selected service, the Event Waits table shows data for each wait event associated with the service, together with the rate of waits, and time waited over the past time period.

Column

Description

Event The name of the event.
Total Waits The total number of waits.
Waits/s How many waits per second.
Total Wait Time The total amount of the time waited, measured in milliseconds.
Wait Time/s The number of milliseconds waited per second.

The Event Waits Chart

For the selected service, this shows the rate at which sessions have spent waiting on various events. Event wait categories from V$SYSTEM_EVENT are aggregated so that they can be plotted on the chart.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating