Multiple choice

Which of the following is/are true about Automatic Database Diagnostic Monitor (ADDM) in automatic performance tuning of oracle database?

  1. It is used to collect, process, and maintain performance statistics for problem detection and self-tuning purposes

  2. It is used to analyse the information collected by the AWR for possible performance problems with the Oracle database.

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

  4. It provides end-to-end application tracing.

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

This is correct statement about Automatic Database Diagnostic Monitor (ADDM).

Keep practicing — related questions