Validating Statistics Findings from Automatic SQL Tuning Advisor

You can validate the impact of statistics findings from Automatic SQL Tuning Advisor using SPA Quick Check.

Note:

You can use SPA Quick Check to validate the impact of validating statistics findings from Automatic SQL Tuning Advisor in databases running Oracle Database 11g Release 1 (11.1) and later.

To validate the impact of statistics findings from Automatic SQL Tuning Advisor:

  1. On the Database Home page in Cloud Control, from the Performance menu, select Advisors Home.The Advisor Central page appears.

  2. In the Advisors section, click SQL Advisors.The SQL Advisors page appears.

  3. In the SQL Tuning Advisor section, click Automatic SQL Tuning Results.The Automatic SQL Tuning Result Summary page appears.

  4. If any statistics findings are available, they appear in the Statistics Finding Summary section near the bottom of the page. To validate the impact of statistics findings in user schemas, click Validate with SPA.A Confirmation statement appears at the top of the page that indicates a SPA task for validating the statistics findings has been submitted.

  5. Click the link for the SPA task in the Confirmation statement.The SQL Performance Analyzer Home page appears, and the SPA task for validating the statistics findings appears in the SQL Performance Analyzer Tasks table at the bottom of the page.

  6. After all the steps in the task have completed successfully, and Completed appears in the Last Run Status column of the table, select the task and click View Latest Report. It may take several minutes for all of the steps in the task to complete.The SQL Performance Analyzer Task Report page appears.

  7. View the table at the bottom of the page to see what the result would be of implementing the statistics on the Automatic SQL Tuning Result Summary page on the most impactful SQL statements in the workload.