What action would you take to achieve this task?

Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?

Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future. What action would you take to achieve this task?

A.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid the automatic purging of the snapshots.

B.
Set the STATISTICS_LEVEL initialization parameter to ALL.

C.
Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.

D.
Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.



Leave a Reply 0

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