Which tuning tool recommends how to optimize materialized views so that these views can take
advantage of the general query rewrite feature?
A.
Segment Advisor
B.
SQL Access Advisor
C.
Undo Advisor
D.
SQL Tuning Advisor
Explanation:
SQL Access Advisor recommends how to optimize materialized views so that these views can
take advantage of the general query rewrite feature. To achieve optimum performance forcomplex, data-intensive queries, you need to use materialized views and indexes. The SQL
Access Advisor helps you achieve your performance goals by recommending the proper set of
materialized views, materialized view logs, and indexes for a given workload. The SQL Access
Advisor can use current SQL, an existing SQL Tuning Set (STS), or a hypothetical workload to
make its recommendations. The option stating ADDM is incorrect. ADDM recommendations are
based on the following:
– Hardware changes – Adding CPUs or changing the I/O subsystem configuration
– Database configuration – Changing initialization parameter settings
– Schema changes – Hash partitioning of a table or index
– Application changes – Using the cache option for sequences or using bind variables
– Using other advisors – Running the SQL Tuning Advisor on high load SQL
or running the Segment Advisor on hot objects ADDM does not recommend how to optimize
materialized views.
The Undo Advisor does not recommend how to optimize materialized views. The Undo Advisor
helps you to estimate the space that you will need to store undo information.
Segment Advisor does not recommend how to optimize materialized views. Segment Advisor
helps to determine whether an object has space available for reclamation.