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
Click SQL & Application Workload | Analyze Trace | Trace Files.
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. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center