OCP-1Z0-053-V13.02-691题

691. You work in a data warehouse environment that involves the execution  of complex queries. The

current content of the SQL cache contains the ideal workload for analysis. You want to analyze only a few

most resource-intensive statements.

What must you do to receive recommendations on efficient use of indexes and materialized views to

improve query performance?

A.Run the SQL Access Advisor.

B.Run the SQL Tuning Advisor (STA).

C.Run the Automatic Workload Repository (AWR) report.

D.Run the Automatic Database  Diagnostic Monitor (ADDM).

Answer: A 

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94878

Figure 18-1 illustrates how SQL Access Advisor recommends access structures for a given workload obtained from a user-defined table or the SQL cache. If a workload is not provided, then it can generate and use a hypothetical workload also, provided the user schema contains dimensions defined by the CREATEDIMENSION keyword.

Figure 18-1 Materialized Views and SQL Access Advisor

Description of "Figure 18-1 Materialized Views and SQL Access Advisor"

Using SQL Access Advisor in Enterprise Manager or API, you can do the following:

• Recommend materialized views and indexes based on collected, user-supplied, or hypothetical workload information.

• Recommend partitioning of tables, indexes, and materialized views.

• Mark, update, and remove recommendations.

In addition, you can use SQL Access Advisor API to do the following:

• Perform a quick tune using a single SQL statement.

• Show how to make a materialized view fast refreshable.

• Show how to change a materialized view so that general query rewrite is possible.

  
  
  来源： <http://docs.oracle.com/cd/E11882_01/server.112/e41573/advisor.htm#PFGRF94878>