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 2

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


L. Zhu

L. Zhu

AWR baseline template is to capture performance info for the future

D is right