Spotlight on Oracle 10.4

Chatta subito con l'assistenza

Spotlight on Oracle 10.4 - Release Notes

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

Open the SQL Performance page. Select a SQL statement from the SQL Performance Predictions grid.
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.

Spotlight on Oracle 10.4 - Release Notes