Chat now with support
Chat mit Support

Spotlight on Oracle 10.5 - Release Notes

Waits Page

The Waits page displays information about wait events for the selected SQL statement.

The grids in this page are similar to the grids in the Analyze Trace | Summary Page, but apply to a specific SQL statement, not the entire contents of a trace file.

To open the Waits page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click SQL & Application Workload | Analyze Trace | Trace Files.

  3. Select a Trace File.
  4. If the trace file has not been analyzed yet, right-click its row in the Trace File Details table and select Analyze Trace File. Analyze Trace Settings Dialog
  5. Click SQL Statements Page and select a SQL statement.
  6. Click SQL Statement Details Page | Waits.

Types of Waits

The Types of Waits table shows the following information about wait categories in the selected SQL statement:

Column Description

Top Category

High-level event categories for waits in the trace file.

Sub Category

Event categories for waits in the trace file.

Count

The number of times a wait event in the specified category has occurred.

Time (ms)

The amount of time spent on waits in the specified category.

Wait Details

The Wait Details table lists all the wait events for the wait category currently selected in the Types of Waits table for the selected SQL statement.

Column Description
Wait

For the specified SQL statement, this column lists every wait in the category currently selected in the Types of Waits table.

Object

The Oracle object to which each wait applies.

Count

The number of times the specified wait has occurred.

Elapsed Time (ms)

The amount of elapsed time spent on the specified wait.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen