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, Summary Time Period, 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. The next line in this section shows the status of Automatic Implementation of SQL Profiles as being currently Disabled. Next to this status is a button labeled Configure. The last status line displayed in this section is the number of Key SQL Profiles, which is zero.
The Summary Time Period section has fields that allow you to set the time period for the data displayed in the 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.
The Overall Task Statistics section starts with the following information: Execution 4, Candidate SQL 52, Distinct SQL Examined 46. There are two charts in this section. The SQL Examined Status pie chart displays proportion of SQL Examined With Findings (26), SQL Examined Without Findings(20), and SQL Skipped Due To Errors (0). In the pie chart, SQL Examined Without Findings constitutes 43% and SQL Examined With Findings constitutes 57% of the total area.
The second chart in the Overall Task Statistics section is the Breakdown by Finding Type bar chart. This chart shows the Number of SQL statements (vertical axis) for each of the following categories (horizontal axis): SQL Profile, Index, Statistics, Restructure SQL, and Alternative Plan. In the chart shown in the screenshot, the number of SQL statements for each category is: SQL Profile (8), Index (12), Statistics (19), Restructure SQL (2), and Alternative Plan (18).
The section Profile Effect Statistics contains a bar chart titled Workload Potential DB Time Benefit (seconds per week). Under the title there are two values shown: Implemented (sec), which shows 7, and Potential Benefit (sec), which shows 203. The vertical axis on the bar chart is labeled DB Time (s), with values ranging from 0 to 900. The horizontal axis has two categories: Implemented and Recommended. There is no data for the Implemented category. For the Recommended category, there are two values displayed: Before and After, as side-by-side bars. These bars show approximately 850 seconds for Before and approximately 600 seconds for After.
End of description.