OCP-1Z0-053-V13.02-691题
来源:互联网 发布:上古卷轴5enb优化 编辑:程序博客网 时间:2024/04/30 10:54
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 CREATE
DIMENSION
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>
- OCP-1Z0-053-V13.02-691题
- OCP-1Z0-053-V13.02-1题
- OCP-1Z0-053-V13.02-682题
- OCP-1Z0-053-V13.02-687题
- OCP-1Z0-053-V13.02-692题
- OCP-1Z0-053-V13.02-696题
- OCP-1Z0-053-V13.02-711题
- OCP-1Z0-053-V13.02-710题
- OCP-1Z0-053-V13.02-709题
- OCP-1Z0-053-V13.02-708题
- OCP-1Z0-053-V13.02-706题
- OCP-1Z0-053-V13.02-490题
- OCP-1Z0-053-V13.02-24题
- OCP-1Z0-053-V13.02-36题
- OCP-1Z0-053-V13.02-43题
- OCP-1Z0-053-V13.02-45题
- OCP-1Z0-053-V13.02-60题
- OCP-1Z0-053-V13.02-651题
- 《STL源码剖析》——迭代器(iterators)概念与traits编程技法(一)
- Advice on improving your programming skills
- SQL SERVER的表锁
- ATL与WTL中CString的使用, 利用ATLCString获得窗口的文字.
- Bee-Framework初探
- OCP-1Z0-053-V13.02-691题
- WebSphere7.0生成core文件和dump文件的方法
- The resource identified by this request is only capable of generating responses with characteristics
- 【简单数学】ZOJ 2975 Kinds of Fuwas
- nginx---stubstatus
- java算法买苹果
- 【c++】PAT (Advanced Level)1010. Radix (25)
- Vijos P1102 陶陶摘苹果
- 链表