Copyright © 2004, 2012, Oracle and/or its affiliates. All rights reserved.
Legal Notices
This is a screenshot of a portion of the Automatic SQL Tuning Result Details page. Its main element is a table of recommendations. The table columns shown in the screenshot are: Select, SQL Text, Parsing Schema, SQL ID, Weekly DB Time Benefit(sec), Per-Execution % Benefits, Statistics, SQL Profile, Index. The columns Statistics, SQL Profile, and Index contain check marks, indicating that this type of recommendation is made. The SQL ID column contains hyperlinks to SQL details.
An example of the data in the table is:
SQL Text: SELECT COUNT(*) FROM HR.EMPLOYEES E, HR.....
Parsing Schema: SH
SQL ID: (hyperlink) f8ybh6brs1uq2
Weekly DB Time Benefit(sec): 162.57
Per-Execution % Benefit: 22
Statistics: <null>
SQL Profile: (22%), followed by a checkmark
Index: <null>
Above the table is a View Recommendations button and an Implement All SQL Profiles button.
End of description.