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)- A7% (2)
- B19% (5)
- C4% (1)
- D70% (19)
Community Discussion
No community discussion yet for this question.