ITPub博客

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

043-001

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-04 09:18:06 0 删除 编辑
1.You observe that a database performance has degraded over
a period of time. While investigating the reason, you find the size of
the database buffer cache is not large enough to cache all the needed data
blocks. Which advisory component wold you refer to, in order to determine
that required size of the database buffer cache?
A. Memory Advisor
B. Segment Advisor
C. SQL Tuning Advisor
D. SQL Access Advisor
E. Automatic Database Diagnostic Monitor(ADDM)
Answer: A
Memory Advisor:oracle 用它来优化内存sga分配和pga分配的。如果是asmm管理模式,memory advisor会调节整体的sga,如果不是asmm的,它会调整内存分配,和asmm的分别应该是一个是动态的,一个是静态的。

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    205828