Description of the illustration perf_finding_details.gif

This screenshot shows the top portion of the Performance Finding Details: Top SQL Statements page.

In the upper right of the screenshot are the following buttons: Finding History.

6 label-value pairs appear. The value for the Finding label is: SQL statements consuming significant database time were found. These statements offer a good opportunity for performance improvement. The value for the Impact (Active Sessions) label is: .4. The value for the Percentage of Finding's Impact (%) label is: 69.3. The value is displayed as a horizontal bar. The value for the Period Start Time label is: Dec 30, 2011 3:30:31 PM. The value for the End Time label is: Dec 30, 2011 4:00:45 PM. The value for the Filtered label is: No. The Filters button appears next to this value.

This screenshot shows the Recommendations section of the page. This section has the Schedule SQL Tuning Advisor button and a table.

Above the table are the following options: Select All, Select None, Show All Details, Hide All Details.

The table contains the following columns: Select, Details, Category, and Benefit (%). The value of the Select column is a check box. The value of the Details column is a collapsible navigation tree. The value of the Benefit column is a horizontal bar chart with an associated number.

5 rows are shown in the table. The values of row 1 are: not selected, Show, SQL Tuning, and 29.7. The values of row 2 are: selected, Show, SQL Tuning, and 10.9. The values of row 3 are: not selected, Show, SQL Tuning, and 10.9. The values of row 4 are: not selected, Show, SQL Tuning, and 9.9. The values of row 5 are: selected, Show, SQL Tuning, and 5.

End of description.