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
Explanation:
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 shrink when table and
index segments are heavily fragmented.