Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.6 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Advanced SQL Details

Advanced SQL Details contains statistical details on the data displayed in the other pages of the SQL Performance page.

To open the Advanced SQL Details page

  1. Open the SQL Performance page. Select a SQL statement from the SQL Performance Predictions grid.

  2. Click Advanced SQL Details.

Advanced SQL Statement Information

Category of data on the grid Description

General

The results of the analysis as shown in the cost summary:

  • The current cost of the SQL statement as a percentage of the total current cost.
  • The predicted cost of the SQL statement as a percentage of the total predicted cost at the end-date.
  • The increase in the cost of the SQL statement at the end-date as a percentage of the current cost.
  • The increase in the number of cost events (for example, buffer gets) for the SQL statement between now and the end-date.

{Cost Metric} / Second

Detail used to construct the chart in the {Predict for:} / Sec Versus Time page.

{Cost metric} / Execution

Detail used to construct the chart in the {Predict for:} / Execution Versus Time page.

Executions / Second

Detail used to construct the chart in the Executions / Sec Versus Time page.

SQL Statement

The identity and text of the SQL statement used to generate the analysis.

 

Related Topics

SQL Performance

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation