ITAA-OCM 发表于 2012-3-12 17:42:58

Oracle OCP题库原创解析（50）

You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis.You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the 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题目中提到分析走索引还是物化视图来提高性能，所以用SQL Access Advisor分析

小夏88 发表于 2018-8-18 20:53:23

666

小夏88 发表于 2018-8-18 20:53:28

6666

小夏88 发表于 2018-8-18 20:53:33

6666

小夏88 发表于 2018-8-18 20:53:38

6666

小夏88 发表于 2018-8-18 20:53:44

66666

小夏88 发表于 2018-8-18 20:53:49

6666

小夏88 发表于 2018-8-18 20:53:56

666666

小夏88 发表于 2018-8-18 20:54:02

666666666

小夏88 发表于 2018-8-18 20:54:07

666

小夏88 发表于 2018-8-18 20:54:12

6666

小夏88 发表于 2018-8-18 20:54:17

6666666

小夏88 发表于 2018-8-18 20:54:22

66666

小夏88 发表于 2018-8-18 20:54:28

66666666

simeonlan 发表于 2018-9-2 14:38:56

谢谢楼主
最好是汇总一下
页: [1] 2
查看完整版本: Oracle OCP题库原创解析（50）