Multiple choice

Which of the following is/are true about Automatic Workload Repository (AWR) in automatic performance tuning ?

  1. It is responsible for maintaining performance statistics for problem detection and self-tuning purposes.

  2. It provides a quick and efficient technique for optimizing SQL statements without modifying any statements.

  3. It provides advice on materialized views, indexes, and materialized view logs.

  4. It provides server generated alerts.

  5. Both (1) and (2)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

AWR maintains the statistics report for the processes and their related problems.

Keep practicing — related questions