1Z0-062 · Question #213
Your database has been running with a peak load for the past hour. You want to preserve the performance statistics collected during this period forcomparison when you analyze the performance of the…
The correct answer is B. Createa baseline on a pair of snapshots that span the peak load period. To preserve specific performance statistics from a peak load period for future comparison, you must create an AWR baseline that includes the relevant AWR snapshots.
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 forcomparison when you analyze the performance of the database later. What must you do to achieve this?
Options
- AIncrease the window size of the moving window baseline so that it equals the Automatic
- BCreatea baseline on a pair of snapshots that span the peak load period.
- CGenerate Active Session History reports for the peak load period.
- DSet the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the
How the community answered
(26 responses)- A12% (3)
- B77% (20)
- C4% (1)
- D8% (2)
Why each option
To preserve specific performance statistics from a peak load period for future comparison, you must create an AWR baseline that includes the relevant AWR snapshots.
Increasing the window size of a moving window baseline only extends the rolling period for which AWR snapshots are preserved, but does not specifically target and permanently retain a particular historical peak load period.
Creating an AWR baseline on a pair of snapshots that encompass the peak load period explicitly preserves those specific snapshots from being purged, allowing for their use in future performance comparisons against current or other historical data.
While generating Active Session History (ASH) reports provides detailed performance insights, it only displays data from existing snapshots and does not prevent the underlying AWR or ASH data from being automatically purged.
Setting the AWR snapshot retention period extends the retention for *all* snapshots, consuming more storage space broadly, rather than precisely preserving only the performance statistics relevant to the identified peak load period.
Concept tested: AWR Baselines for performance data retention
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/managing-baselines-in-awr.html#GUID-FCB20320-80D3-487D-8975-E6A2665B35C1
Topics
Community Discussion
No community discussion yet for this question.