Which two statements are true about the report produced by this script?

A batch workload that historically completed in the maintenance window between 10:00 PM and
midnight is currently showing poor performance and completing at 2 AM. To help in the diagnosis
of the performance degradation, the senior DBA in your organization asks you to execute the
awrddrpt.sql script to produce a Compare Periods report. Which two statements are true about the
report produced by this script? (Choose two.)

A batch workload that historically completed in the maintenance window between 10:00 PM and
midnight is currently showing poor performance and completing at 2 AM. To help in the diagnosis
of the performance degradation, the senior DBA in your organization asks you to execute the
awrddrpt.sql script to produce a Compare Periods report. Which two statements are true about the
report produced by this script? (Choose two.)

A.
It is refreshed automatically based on the moving window baseline.

B.
It compares details between any two selected time periods of the same duration.

C.
It normalizes the statistics by the amount of time spent on the database for each time period.

D.
It compares details between two consecutive time periods of the same or different durations
and is refreshed every 60 minutes.



Leave a Reply 1

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


L. Zhu

L. Zhu

A is wrong.
B is right. why same period? but choose 2, we need this one
C is right.
D is wrong. not two consecutive periods

So B.D. are correct