Description of the illustration auto_sqlt_advisor.gif

This is a screen shot of the SQL Tuning Advisor page with the Automatic tab showing. At the top of the page, Show All is the selected value in the Automatic Runs field. To the right of the Automatic Runs field is the Configuration button. At the top right of the page, the Page Refreshed field shows the time that the page was last refreshed, and the Auto Refresh field shows the refresh interval currently set for this page. The table shows information about the Automatic SQL Tuning Advisor task named SYS_AUTO_SQL_TUNING_TASK, which runs daily.

On the left below the page name is the Status section. This includes the following fields and values:

To the right of the Status section is the Findings Overview section, which includes these three charts from right to left:

The Top SQL Statements table appears at the bottom of the page. On the left, just above the table, the View Details and Implement All SQL Profiles buttons appear. On the right, just above the table, the SQL Profile Verified check box and the Search field for the table appear.

The columns in the table (from left to right) are SQL Text, Id, Schema, Cumulative DB Time Benefit, Per-Execution Benefit, Statistics, SQL Profile, Index, Restructure SQL, Alternative Plan, Miscellaneous, and Timeout.