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 *