设为首页收藏本站language→→ 语言切换

鸿鹄论坛

 找回密码
 论坛注册

QQ登录

先注册再绑定QQ

查看: 3009|回复: 17
收起左侧

[题库] Oracle OCP题库原创解析(50)

[复制链接]
发表于 2012-3-12 17:42:58 | 显示全部楼层 |阅读模式
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分析

发表于 2018-9-2 14:38:56 | 显示全部楼层
谢谢楼主
最好是汇总一下
15# 2018-9-2 14:38:56 回复 收起回复
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 论坛注册

本版积分规则

QQ|Archiver|手机版|小黑屋|sitemap|鸿鹄论坛 ( 京ICP备14027439号 )  

GMT+8, 2024-3-28 22:00 , Processed in 0.071152 second(s), 8 queries , Redis On.  

  Powered by Discuz!

  © 2001-2024 HH010.COM

快速回复 返回顶部 返回列表