Chat now with support
Chat with Support

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating