QUESTION 58-ADDM

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference.
You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation.
Which three findings would you get from the report?
A. It detects any configuration change that caused a performance difference in both time periods.
B. It identifies any workload change that caused a performance difference in both time periods.
C. It detects the top wait events causing performance degradation.
D. It shows the resource usage for CPU, memory, and I/O in both time periods.
E. It shows the difference in the size of memory pools in both time periods.
F. It gives information about statistics collection in both time periods.
Correct Answer: ABD
Section: (none)

Keyword: shows the difference.
* Full ADDM analysis across two AWR snapshotperiods Detects causes, measure effects, then correlates them Causes: workload changes, configuration changes Effects: regressed SQL, reach resource limits (CPU, I/O, memory, interconnect) Makes actionable recommendations along with quantified impact
* Identify what changed / Configuration changes, workload changes
* Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.
While an AWR report shows AWR data between two snapshots (or two points in time), the AWR Compare Periods report shows the difference (ABE) between two periods (or two AWR reports with a total of four snapshots). Using the AWR Compare Periods report helps you to identify detailed performance attributes and configuration settings that differ between two time periods.

 

您注意到生产Oracle数据库中的一个性能更改，您想知道是哪个更改造成了这个性能差异。

您将生成比较周期自动数据库诊断监视器(ADDM)报告以进行进一步的调查。

你会从报告中得到哪三项发现?

A.它检测在两个时间段内导致性能差异的任何配置更改。

b.它识别在两个时间段内导致性能差异的任何工作负载更改。

C.检测导致性能下降的top等待事件。

D.显示两个时间段内CPU、内存和I/O的资源使用情况。

它显示了两个时间段内内存池大小的差异。

F.它提供了关于两个时间段的统计数据收集的信息。

正确答案:ABD

部分:(一)

 

关键词:显示差异。

*跨两个AWR snapshotperiod的完整ADDM分析检测原因，测量影响，然后关联它们的原因:工作负载更改，配置更改

*识别什么改变了/配置改变了，工作负载改变了

*数据库性能下降发生在数据库在过去的最佳性能时，比如6个月前，但已经逐渐下降到用户会注意到的程度。通过自动工作负载存储库(AWR)比较时间段报告，您可以比较两个时间段之间的数据库性能。

AWR报告显示两个快照(或两个时间点)之间的AWR数据，而AWR比较周期报告显示两个时间段(或两个总共有四个快照的AWR报告)之间的差异(ABE)。使用AWR比较时间段报告可以帮助您识别在两个时间段之间不同的详细性能属性和配置设置。