nerdexam
Oracle

1Z0-054 · Question #167

In a database, the values for transactions per second are higher during working hours and lower during nonworking hours. You want to receive alerts in future time periods if the daytime performance…

The correct answer is D. the Automatic Workload Repository (AWR) baseline template. See the full explanation below for the reasoning.

Question

In a database, the values for transactions per second are higher during working hours and lower during nonworking hours. You want to receive alerts in future time periods if the daytime performance varies compared to the captured daytime performance or the nighttime performance varies compared to the captured nighttime performance, over a repeating time period. This would permit the DBA to perform additional performance tuning operations. Which feature would you use to record this variation in performance statistics?

Options

  • ASQL tuning set
  • BSQL plan baselines
  • Cthe Automatic Workload Repository (AWR) baseline
  • Dthe Automatic Workload Repository (AWR) baseline template

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    19% (5)
  • C
    4% (1)
  • D
    70% (19)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice