Description of the illustration sql_access_results_details.gif

The screenshot shows the Details subpage of the Results for Tasks page. The Details subpage has two tables: Workload and Task Options, and Journal Entries.

The Workload and Task Options table has descriptive text below the title that reads, "These are the options that were selected when the advisor task was created." Below this text, on the right-hand side of the page is a link for the previous page (disabled), a list for selecting the options to display (the value "1-10 of 29" is selected), and a link for Next 10. The table has 3 columns, which are named, from left to right: Option, Value, and Description. There are 10 rows displayed in the table. They contain the following values, in column order from left to right and row order from top to bottom:

• Advisor Mode, Limited, Specifies the mode in which SQL Access Advisor will operate during an analysis, either limited (quicker results) or comprehensive (higher quality recommendations)

• Analysis Scope, All Tuning Artifacts, The type of recommendations that are allowed

• Creation Cost, Consider creation cost, When specified, the SQL Access Advisor will weigh the cost of creation of access structures against the frequency of the queries and potential improvement in query execution time

• Default Index Schema, None, Specifies the default owner for new index recommendations

• Default Index Tablespace, None, Specifies the default tablespace for new index recommendations

• Default MVLog Tablespace, None, Specifies the default tablespace for new materialized view log recommendations

• Default MView Schema, None, Specifies the default owner for new materialized view recommendations

• Default MView Tablespace, None, Specifies the default tablespace for new materialized view recommendations

• Default Partitioning Tablespaces, None, Specifies the default tablespaces for new Partitioning recommendations

• Excluded Actions, None, Contains a list of application actions that are NOT eligible for tuning

Below this table, on the right-hand side of the page is a link for the previous page (disabled), and a list for selecting the options to display (the value "1-10 of 29" is selected), and a link for Next 10.

The Journal Entries table has descriptive text below the title that reads, "These are the messages that were logged to the advisor journal while the task was executing. The amount of information logged is controlled by the 'Journalling Level' option shown in the table above." Below this text, on the right-hand side of the page is a link for the previous page (disabled), and a list for selecting the options to display (the value "1-10 of 19" is selected), and a link for the Next 9. The table has 3 columns, which are named, from left to right: Severity, Entry, and Order. The rows in the table are sorted by the ascending value of the Order column. These rows contain the following values, in column order from left to right and row order from top to bottom:

• Information icon, Preparing workload for analysis, 1

• Warning icon, Missing statistics: Table: "SH"."PROMOTIONS", 2

• Information icon, Filter Summary: Valid username: Statements discarded: 1519, 3

• Information icon, Filter Summary: Invalid username: Unused, 4

• Information icon, Filter Summary: Valid module: Unused, 5

• Information icon, Filter Summary: Invalid module: Unused, 6

• Information icon, Filter Summary: Valid action: Unused, 7

• Information icon, Filter Summary: Invalid action: Unused, 8

• Information icon, Filter Summary: Valid SQL String: Unused, 9

• Information icon, Filter Summary: Invalid SQL String: Statements discarded: 0, 10

End of description.