The screenshot shows the Automatic SQL Tuning Result Summary page. There are four sections on the page. Listed in order from top to bottom, they are Task Status, Task Activity Summary, Overall Task Statistics, and Profile Effect Statistics.
The Task Status section shows the status of the task Automatic SQL Tuning (SYS_AUTO_SQL_TUNING_TASK) as being currently Enabled. Next to this status is a button labeled Configure. Next it shows the status of Automatic Implementation of SQL Profiles as being currently enabled. The last status displayed in this section is the count of Highly Recommended SQL Profiles, which is currently zero.
The Task Activity Summary section has fields that allow you to set the time period for the data displayed in Overall Task Statistics and Profile Effect Statistics sections. The Time Period field currently displays the value All. Next to the Time Period field are two buttons: Go and View Report. Below the Time Period field are two dates, corresponding to the Begin Date and End Date of the selected time period.
In the Overall Task Statistics section there are two charts. The SQL Examined Status pie chart displays proportion of SQL statements examined with findings (36), skipped due to errors (0), and examined without findings (34). The Breakdown by Finding Type bar chart shows the Number of SQL statements findings that were implemented or not implemented for the following categories: SQL Profile, Index, Statistics, and Restructure SQL. In the chart shown in the screenshot, only the SQL Profile category has any implemented findings. The category with the highest number of SQL statements is Statistics, followed by SQL Profile, Restructure SQL, and Index, in that order.
The section Profile Effect Statistics contains a bar chart titled Tuned SQL DB Time Benefit (seconds per week). Under the title there are two values shown: Implemented (sec), which shows 7, and Potential (sec), which shows 27. The vertical axis on the bar chart is labeled DB Time (s), with values ranging from 0 to 200. The horizontal axis has two categories: Implemented and Recommended. For each category, there are two values displayed: Before and After, as side-by-side bars. The first category, Implemented, has a very low value (approximately 7 seconds) for Before and zero seconds for After. The second category, Recommended, shows approximately 150 seconds for Before and approximately 123 seconds for After.
End of description.