Chat now with support
Chat with Support

Spotlight on Oracle 10.10 - Release Notes

Overall Statistics Page

Overall Statistics displays statistical information about the selected SQL statement.

To open the Overall Statistics 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 | Overall Statistics.

Overall Statistics Grid

The grid may provide advice on how to improve the performance of the selected SQL statement.

Column Description


The name of a SQL statistic for the selected statement.


The value of the statistic within the chosen trace file.


Advice on how to optimize the performance of the SQL statement.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating