Your database supports a Decision Support System (DSS) workload that involves the
execution of complex queries. Currently, the database is running with peak workload. You
want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and
materialized views to improve query performance?
A.
SQL Performance Analyzer
B.
SQL Access Advisor
C.
SQL Tuning Advisor
D.
Automatic Workload Repository (AWR) report
E.
Automatic Database Diagnostic Monitor (ADDM)
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160 (4th
para)
B
B
Im not sure about the question. Can anyone explain or give a small demo? Thanks!
I think B.
http://docs.oracle.com/cd/B28359_01/server.111/b28275/tdppt_sqltune.htm#TDPPT160
I go for C:
“SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views.”
(OCP_L’s link)
I Think B.
SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views. SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements. If significant performance improvements can be gained by creating a new index, then SQL Tuning Advisor may recommend it. However, such recommendations should be verified by running SQL Access Advisor using a SQL workload that contains a set of representative SQL statements.
https://docs.oracle.com/database/121/TDPPT/tdppt_sqltune.htm#TDPPT161
B