ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-054

043-054

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-06 10:45:10 0 删除 编辑
54. You find that the execution time of reports in your datawarehouse
application is significantly high. You suspect the lack of indexes to
be the reason for the degradation in performance. Which advisory comp
onent would you refer to, in order to determine the appropriate index
es?
A. Memory Advisor
B. Segment Advisor
C. SQL Access Advisor
D. Automatic Workload Repository (AWR)
E. Automatic Database Diagnostic Monitor (ADDM)
Answer: C
你发现你的数据仓库中的执行报告时间非常慢,你怀疑是缺少相应的索引,
可以使用SQL Access Advisor(SQL 访问指导)
SQL 访问指导:处理方案问题并确定最佳数据访问路径(如索引和实体化视
图) 。实体化视图=物化试图
物化视图是包括一个查询结果的数据库对像,它是远程数据的的本地副本,
或者用来生成基于数据表求和的汇总表。物化视图存储基于远程表的数据,也可
以称为快照。
With the Memory Advisor, you can tune the size of your memory structures. If Automatic
Shared Memory Management is enabled, you can use this to tune the total size of the SGA. If
ASMM is disabled, you can use this advisor to tune the different components of the SGA.

Segment Advisor: Monitors object space issues and analyzes growth trends

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-717813/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-053
下一篇: 043-055
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    205486