Description of the illustration spa_task_param_change.gif

The SQL Performance Analyzer Task: SYS.SPA_PARAM_CHANGE page is shown. The Page Refreshed field shows May 1, 2012 5:14:01 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 Create SQL Trial button is shown.

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 db_file_multiblock_read_count set to 128, 5/1/12 5:41 PM, Yes, COMPLETED.

Row 2 has the following values: SECOND_SQL_TRIAL, parameter db_file_multiblock_read_count set to 64, 5/1/12 5:42 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/1/12 5:42 PM, COMPLETED, (sunglasses icon), and null.

End of description.