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?

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.

Show Hint

Leave a Reply 12

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

Vonpire

Vonpire

I thinks it’s A

http://docs.oracle.com/cd/E24628_01/server.121/e55047/tdppt_degrade.htm#TDPPT525

From the documentation:

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.

Reply

Tri

Tri

Thanks Vonpire!

Reply

Tri

Tri

A. Thanks again Vonphire.

From the documentation:

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.

Reply

Vonpire

Vonpire

Another statement that supports it (taken from another user RS VASAN)

In addition to letting you compare performance between two time periods, the AWR Compare Periods Reports capability also lets you compare performance between DB Replay capture and replay-and even between two different DB replays.
Regardless of the nature of comparison, you still need to analyze the huge volumes of performance differentials between them. The AWR Compare Period Reports don’t map the root causes to performance changes.
Oracle 12c offers you something that takes you further in your search for the reason for a performance change – the Compare Period ADDM Report. This report performs a cause-to-effect analysis, making it simpler to understand why performance deviated from a base time.
Reference: Oracle 12c New Features – By Sam Alapati

Reply

RNW

RNW

I know it’s A – I use this day in an day out.

Reply