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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Analyze Trace | Trace Files.
- Select a Trace File.
- 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
- Click SQL Statements Page and select a SQL statement.
- 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. |