Description of the illustration spa_task_optimizer.gif

The SQL Performance Analyzer Task: SYS.SPA_OPTIMIZER_STATS page is shown. The Page Refreshed field shows May 26, 2012 12:53:51 PM PDT. The Refresh button is shown.

The SQL Tuning Set section is collapsed.

The SQL Trials section includes the following text: "A SQL Trial captures the execution performance of the SQL Tuning Set under specific environmental conditions."

The table includes the following columns: SQL Trial Name, Description, Created, SQL Executed, and Status.

Row 1 has the following values: INITIAL_SQL_TRIAL, parameter optimizer_use_pending_statistics set to FALSE, 5/2/12 1:45 PM, Yes, COMPLETED.

Row 2 has the following values: SECOND_SQL_TRIAL, parameter optimizer_use_pending_statistics set to TRUE, 5/2/12 1:45 PM, Yes, COMPLETED.

The SQL Trial Comparisons section is shown. The text is: "Compare SQL Trials to assess change impact of environmental differences on SQL Tuning Set execution costs." The Run SQL Trial Comparison button is shown.

The table has the following columns: Trial 1 Name, Trial 2 Name, Compare Metric, Created, Status, Comparison Report, and SQL Tune Report.

Row 1 has the following values: INITIAL_SQL_TRIAL, SECOND_SQL_TRIAL, Elapsed Time, 5/2/12 1:46 PM, COMPLETED, (sunglasses icon), and null.

End of description.