Chat now with support
Chat mit Support

Spotlight on Oracle 10.5 - 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

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.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen