The SQL Performance Analyzer: Task Result: SYS.SORT_TIME page is shown.

In the summary at the top of the page, the Task Name is SORT_TIME. The Task Owner is SYS. The Task Description field is "Double the value of SORT_AREA_SIZE". The SQL Tuning Set Name is STS_AWR. The STS Owner is IMMCHAN. The Total SQL Statements field shows 1653. The SQL Statements With Errors field shows 145. The SQL Trial 1 name is INITIAL_SQL_TRIAL. The SQL Trial 2 name is SECOND_SQL_TRIAL. The Comparison Metric is Elapsed Time.

Below the summary is the Global Statistics section, which includes two bar charts.

The chart on the left is labeled Projected Workload Execute Elapsed Time. It has a y-axis labeled Elapsed Time (sec). The y-axis values ranged from 0 to 1500. The x-axis values are INITIAL_SQL_TRIAL (blue) and SECOND_SQL_TRIAL (orange). The y-axis value of INITIAL_SQL_TRIAL is 1400. The y-axis value of SECOND_SQL_TRIAL is 750. The Improvement Impact is 44%. The Regression Impact is -6%. The Overall Impact is 37%.

The chart on the right is labeled SQL Statement Count. The y-axis is labeled SQL Count and ranges from 0 to 2,000. The x-axis is labeled Change in Elapsed Time. The x-axis has the following values: Improved, Regressed, and Unchanged. The bar for Improved has a y-axis value of 0. The bar for Regressed has a y-axis value of 0. The bar for Unchanged is green and has a y-axis value of 1,653, which represents Plan Unchanged. There are no bars colored orange, which represents Plans Changed.

To the right of the SQL Statement Count chart is the Recommendations section. The text reads "Oracle offers two options to fix regressed SQL resulting from plan changes: Use the better execution plan from SQL Trial 1 by creating SQL Plan Baselines. Explore alternate execution plans using SQL Tuning Advisor." The Create SQL Plan Baselines button and Run SQL Tuning Advisor button are shown.

Below the Global Statistics section is the Top 10 SQL Statements Based on Impact on Workload section. The table contains the following columns: null, SQL ID, Net Impact on Workload (%), Elapsed Time INITIAL_SQL_TRIAL, Elapsed Time SECOND_SQL_TRIAL, Net Impact on SQL (%), % of Workload INITIAL_SQL_TRIAL, % of Workload SECOND_SQL_TRIAL, Plan Changed.

End of description.