Which feature would you use to record this variation in performance statistics?

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?

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?

A.
SQL tuning set

B.
SQL plan baselines

C.
the Automatic Workload Repository (AWR) baseline

D.
the Automatic Workload Repository (AWR) baseline template



Leave a Reply 0

Your email address will not be published. Required fields are marked *