nerdexam
Oracle

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.

Managing Performance

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)
  • A
    12% (3)
  • B
    77% (20)
  • C
    4% (1)
  • D
    8% (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.

AIncrease the window size of the moving window baseline so that it equals the Automatic

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.

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

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.

CGenerate Active Session History reports for the peak load period.

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.

DSet the snapshot retention period in AWR to 60 to avoid automatic purging of snapshots for the

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

#performance statistics#AWR#baselines#snapshots

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice