Which method or feature should you use?

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?Comparing Current System Performance to a Baseline Period You may have noticed a performance change on a production system and would like to know why, or you may have implemented a change to a production system and want to know the effect of the change, such as increased concurrency waits. 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. The Advisor can analyze any Oracle RDBMS version 10.2.0.4 or later monitored by Cloud Control. The following procedure explains how to initiate a report from the Compare Period ADDM.

Question:

Which method or feature should you use?

Options:

Compare Period ADDM report

AWR Compare Period report

Active Session History (ASH) report

taking a new snapshot and comparing it with a preserved snapshot

Correct Answer

The Correct Answer for this Question is

AWR Compare Period report

Leave a Comment