QQ:54110058 清江石
声明：对于答案的相关的说明，是个人对 Oracle 的理解和收集相关
资料整理,主要参考了 tianlesoftware 兄资料,供大家参考学习。
2011-08-02
119 跟 43(已经删除)相同
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
你发现你的数据高速缓存区（Database Buffer Cache）不够用了，可以使用 Memory
Advisor 来确定其大小,自动数据库诊断监视器 (ADDM)：执行自上而下的实例分析，确定问
题和潜在的原因，并提供修复问题的建议案。ADDM 可潜在地调用其他指导。SGA 指导（Memory
Advisor）：根据系统全局区(SGA) 中各个组件的访问模式，负责优化和建议 SGA 的大小。
Adequate physical memory has a significant impact on the performance of your
Oracle Database. With its automatic memory management capabilities, Oracle Database
can automatically adjust the memory distribution among the various SGA and PGA
components for optimal performance. These adjustments are made within the boundaries
of the total amount of memory that you allocate to the database.
ADDM periodically evaluates the performance of your database to determine
performance problems. If ADDM finds that the current amount of available memory is
inadequate and adversely affecting performance, then it can recommend that you
increase memory allocations. You can select new memory allocations using the Memory
Advisors.
Additionally, you can use the Memory Advisors to perform what-if analysis on the
following:
The database performance benefits of adding physical memory to your database
The database performance impact of reducing the physical memory available to your
database
With the Memory Advisors, you can obtain memory sizing advice as follows:
If automatic memory management is enabled, then you can get advice for setting
the target amount of memory to allocate to the Oracle instance.
If automatic memory management is disabled and automatic shared memory management
is enabled, then you can get advice on configuring the target sizes of the SGA and
剩余121页未读，继续阅读
资源评论
oracle_oracle12012-12-07好材料~~题库+解析。
