Multiple choice technology databases

Multiple baseline metrics can be gathered and stored in the AWR. Why might you want more than one metrics baseline?

  1. You might want a separate baseline metric for each user.

  2. You might want a separate baseline metric for daytime usage versus off-hours usage.

  3. You might want a separate baseline metric for each schema.

  4. You would never want more than one baseline metric, even though it is possible to gather
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Oracle Automatic Workload Repository (AWR) allows multiple baselines to compare performance metrics across different operational periods, such as comparing high-activity daytime workloads against low-activity off-hours or batch-processing windows.

Keep practicing — related questions