Prev Question
Next Question

Your database has been running with a peak load for the past hour. You want to preserve the performance
statistics collected during this period for comparison when you analyze the performance of the database later.
What must you do to achieve this?

Increase the window size of the moving window baseline so that it equals the Automatic Workload
Repository (AWR) snapshot retention period.

Create a baseline on a pair of snapshots that span the peak load period.

Generate Active Session History reports for the peak load period.

Set the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the past hour.

Prev Question
Next Question

Leave a Reply

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