You notice a performance change in your production Oracle 12c database. You want to know
which change caused this performance difference.
Which method or feature should you use?
A.
Compare Period ADDM report
B.
AWR Compare Period report
C.
Active Session History (ASH) report
D.
Taking a new snapshot and comparing it with a preserved snapshot
Explanation:
The awrddrpt.sql report is the Automated Workload Repository Compare Period
Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin directory.
Incorrect:
Not A: Compare Period ADDM
Use this report to perform a high-level comparison of one workload replay to its capture or to
another replay of the same capture. Only workload replays that contain at least 5 minutes of
database time can be compared using this report.
A, because you want to know the CAUSE, and not only what is different
A, thanks
Agreed. Answer is A. https://www.youtube.com/watch?v=7Ag5uQcMS1Y
“A” is the best choice
Not “B” (+/-)
You can export AWR data from the production machine in order to enable detailed analysis of the workload on both systems. This data is required if you plan to run the “AWR Compare Period report” on a pair of workload captures or replays. To export AWR data, you use the DBMS_WORKLOAD_CAPTURE.EXPORT_AWR procedure.
Morris, Matthew (2014-03-20). Study Guide for 1Z0-060: Upgrade to Oracle Database 12c: Oracle Certification Prep (p. 215). ODB Press. Kindle Edition.
“C” Wrong – history have only the last hour and not historical data
“D” (+/-) – snapshots can be taken to generate a report with the latest statistics
I would go with A.
http://www.oracle.com/technetwork/database/manageability/database-manageability-wp-12c-1964677.pdf
The same has been repeated in Question# 58.
It is clearly mentioned that “Compare Period Automatic Database Diagnostic Monitor (ADDM) report” is the correct method.
we came across a cool website that you just could take pleasure in. Take a search in case you want
here are some hyperlinks to web sites that we link to because we believe they are really worth visiting
Here are several of the web pages we recommend for our visitors
we came across a cool website which you may possibly love. Take a look if you want
A
A