Your database is functional with a peak load for the last one hour. You want to preserve the
performance statistics collected during this period to be used for comparison when you analyze the
performance of the database in the future. What action would you take to achieve this task?
A.
Insert finding directives for ADDM tasks in the future.
B.
Create a baseline on a pair of snapshots spanning the peak-load period.
C.
Decrease the snapshot interval in the AWR to collect more snapshots during the peakload period.
D.
Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid
automatic purging of snapshots.
AWR supports the capture of baseline data by enabling you to specify and preserve a pair or range of AWR snapshots as a baseline. The baseline should be a good representation of the peak load on the system. In the future, you can compare these baselines with snapshots captured during periods of poor performance.
• Automatic Workload Repository (AWR): is used for data collection, analysis, and suggests solutions for infrastructure, including database statistics and metrics, Application statistics (transaction volumes and response time), the operating system statistics information and other metrics. Automatic Workload Repository (AWR) through the provision of services for the Oracle server internal components to the collection, processing, maintenance and use performance statistics for problem detection and self-optimizing.
• AWR Baseline: is a period of time collecting a group of AWR snapshots.
Baseline for performance comparison, this comparison may be either the current baseline performance, it can be a baseline comparison with another baseline.
From the title, you can build a snapshot during peak loads to compare performance.