OCP 1Z0 052 46
来源:互联网 发布:数据分析师难考吗 编辑:程序博客网 时间:2024/05/16 14:19
A.The ADDM requires at least four AWR snapshots for analysis.
B.The ADDM runs after each AWR snapshot is collected automatically by MMON.
C.The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR).
D.The ADDM analysis provides only diagnostic information but does not provide recommendations.
E.The ADDM calls other advisors if required, but does not provide recommendations about the advisors.
Answer: BC
A
http://docs.oracle.com/cd/E11882_01/server.112/e41573/diag.htm#PFGRF94240
The time period analyzed by ADDM is defined by the last two snapshots (the last hour by default).
D E
http://docs.oracle.com/cd/E11882_01/server.112/e40540/cncptdba.htm#CNCPT850
Automatic Database Diagnostic Monitor (ADDM) is a self-diagnostic advisor built into Oracle Database. Using statistics captured in AWR, ADDM automatically and proactively diagnoses database performance and determines how identified problems can be resolved. You can also run ADDM manually.
ADDM takes a holistic approach to system performance, using time as a common currency between components. ADDM identifies areas of Oracle Database consuming the most time. For example, the database may be spending an excessive amount of time waiting for free database buffers. ADDM drills down to identify the root cause of problems, rather than just the symptoms, and reports the effect of the problem on Oracle Database overall. Minimal overhead occurs during the diagnostic process.
In many cases, ADDM recommends solutions and quantifies expected performance benefits. For example, ADDM may recommend changes to hardware, database configuration, database schema, or applications. If a recommendation is made, then ADDM reports the time benefit. The use of time as a measure enables comparisons of problems or recommendations.
Besides reporting potential performance issues, ADDM documents areas of the database that are not problems. Subcomponents such as I/O and memory that are not significantly impacting database performance are pruned from the classification tree at an early stage. ADDM lists these subcomponents so that you can quickly see that there is little benefit to performing actions in those areas.
- OCP 1Z0 052 46
- OCP 1Z0 052 1
- OCP 1Z0 052 2
- OCP 1Z0 052 3
- OCP 1Z0 052 4
- OCP 1Z0 052 5
- OCP 1Z0 052 6
- OCP 1Z0 052 7
- OCP 1Z0 052 8
- OCP 1Z0 052 9
- OCP 1Z0 052 10
- OCP 1Z0 052 11
- OCP 1Z0 052 12
- OCP 1Z0 052 13
- OCP 1Z0 052 14
- OCP 1Z0 052 15
- OCP 1Z0 052 16
- OCP 1Z0 052 17
- 平面设计师必备的10大技能
- javascript的map()方法
- Cognos函数(四) - ParamDisplayValue和ParamValue
- 一段关于.net数据库实验的设计思路
- chm文档无法查看,打开后显示“已取消到该网页的导航”
- OCP 1Z0 052 46
- 阿里巴巴全资合并UC优视
- 通过proc fs获取设备状态
- record dump-flow
- VS2012下开发驱动-配置环境
- Java调用C语言Dll库回调函数
- 《快学Scala》第7章 包和引入 练习
- java利用zxing来生成和解析二维码,支持中文
- application、session和request的计数器