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
Suggested Answer:B🗳️
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 Answers: A: Compare Period ADDM is used 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.
The answer is A
Compare Period ADDM report
The Compare Period ADDM compares the performance of the database server in two time periods, and returns a report describing the performance changes and the root origin of the changes.
This section is not available anymore. Please use the main Exam Page.1z0-063 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
chitter
3 years agoNneoma
4 years, 2 months agoNorthKorean
5 years, 1 month ago