Dec 10, 2012 Dear Experts, 11.2.0.3 RDBMS - I ran SQL Tuning Advisor for a statement and see three recommendations:-Gather stats for a table-Implement SQL profile - shows 99% benefit- Index creation - shows about 78% benefit. Tuning advisor recommends only one reco to be implemented. Which one should I be implementing? Also, with SQL profile, I see 'force match' option, what it signifies? The SQL tuning advisor is run against each statement in turn. The outcome may include both SQL profiles and other recommendations. Suggested SQL profiles are performance tested, and those that result in at least a threefold improvement are accepted if the ACCEPTSQLPROFILES parameter is set to TRUE, or reported if it is set to FALSE.
The SQL Tuning Advisor runs automatically during system maintenance windows (time periods) as a maintenance task. During each automatic run, the advisor selects high-load SQL queries in the system and generates recommendations on how to tune these queries.
The Automatic SQL Tuning Advisor can be configured to automatically implement SQL profile recommendations. A SQL profile contains additional SQL statistics that are specific to the SQL statement and enable the query optimizer to generate a significantly better execution plan at run time. If you enable automatic implementation, then the advisor creates SQL profiles for only those SQL statements where the performance improvement would be at least threefold. Other types of recommendations, such as the creation of new indexes, refreshing optimizer statistics, or restructuring SQL, can only be implemented manually. DML statements are not considered for tuning by the Automatic SQL Tuning Advisor.
You can view a summary of the results of automatic SQL tuning, and a detailed report about recommendations made for all SQL statements that the SQL Tuning Advisor has processed. You can then implement selected recommendations. You can also view the recommendations that were automatically implemented.
You can disable the Automatic SQL Tuning Advisor, if desired.
Atlas vst win download. See Also:
'Viewing Automatic SQL Tuning Results'
'Configuring the Automatic SQL Tuning Advisor'
Oracle Database Administrator's Guide for more information about automated maintenance tasks