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?

The correct answer is B. AWR Compare Period report. 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. Not A:Compare Period ADDM Use this report to perform a high-level comparison of one workload replay to its capture…

Using Advanced SQL Features

Question

Options

ACompare Period ADDM report
BAWR Compare Period report
CActive Session History (ASH) report
DTaking a new snapshot and comparing it with a preserved snapshot

How the community answered

(34 responses)

A
12% (4)
B
79% (27)
C
3% (1)
D
6% (2)

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. 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.

Topics

#AWR#performance monitoring#ADDM#diagnostic tools

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice