QUESTION 185
You have a very large table that your users access frequently. Which of the following advisors will recommend
any indexes to improve the performance of queries against this table?
A. The Automatic Memory Manager (AMM)
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor
Answer: D
同44题:http://blog.csdn.net/rlhua/article/details/13504185
Explanation/Reference:
Section: Managing Database Performance & Tuning
The SQL Access Advisor analyzes all SQL running during a given time period and recommends indexes and
materialized views to improve the overall performance of the database.
A is incorrect because there is no such advisor as the Automatic Memory Manager. B is incorrect because the
SQL Tuning Advisor looks only at a single SQL statement and provides recommendations. C is incorrect
because the Segment Advisor recommends segment shrinkwhen table and index segments are heavily
fragmented.