Overall Statistics Page
Overall Statistics displays statistical information about the selected SQL statement.
To open the Overall Statistics 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 | Overall Statistics.
Overall Statistics Grid
The grid may provide advice on how to improve the performance of the selected SQL statement.
| Column | Description |
|---|---|
|
Name |
The name of a SQL statistic for the selected statement. |
|
Value |
The value of the statistic within the chosen trace file. |
|
Advice |
Advice on how to optimize the performance of the SQL statement. |