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
A
B
Performance degradation of the database occurs when your database was performing optimally in the past, such as 6 months ago, but has gradually degraded to a point where it becomes noticeable to the users. The Automatic Workload Repository (AWR) Compare Periods report enables you to compare database performance between two periods of time.
Compare Period ADDM report is like the option button in cloud control, but seems like awr compare period report is the name of the feature.