641.Which three functions are performed by the SQL Tuning Advisor? (Choose three.)
A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans
Answer: ACE
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e40540/cncptdba.htm#CNCPT853
BD属于SQL Access Advisor
SQL Tuning Advisor
Automatic SQL tuning is exposed through SQL Tuning Advisor. SQL Tuning Advisor runs automatically during system maintenance windows as a maintenance task. During each automatic run, the advisor selects high-load SQL queries inthe database and generates recommendations for tuning these queries.
SQL Tuning Advisor recommendations fall into the following categories:
Statistics analysis
SQL profiling
Access path analysis
SQL structure analysis
A SQL profile contains additional statistics specific to a SQL statement and enables the optimizer to generate a better executionplan. Essentially, a SQL profile is a method for analyzing a query. Both access path and SQL structureanalysis are useful for tuning an application under development or a homegrown production application.
A principal benefit of SQL Tuning Advisor is that solutions come from the optimizer rather than external tools (see "Overviewof the Optimizer"). Thus, tuning is performed by the database component that is responsible for the execution plans and SQL performance. The tuning process can consider past execution statistics of a SQL statement and customizes the optimizer settingsfor this statement.