Prev Question
Next Question

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

The awrddrpt.sql report is the Automated Workload Repository Compare Period Report. The awrddrpt.sql script is located in the $ORACLE_HOME/rdbms/admin
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.

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *