Oracle Database 12c: Installation and Administration — Question 54

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

Answer options

• A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.
• B. AWR data is stored in memory and in a database.
• C. All AWR tables belong to the SYSTEM schema.
• D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.
• E. An AWR snapshot contains system-wide tracing and logging information.

Correct answer: A, B, D

Explanation

Options A, B, and D are correct because they accurately describe the functionality and characteristics of AWR, such as how it captures SQL performance data, where the data is stored, and the role of the MMON process. Option C is incorrect as not all AWR tables belong to the SYSTEM schema; they are typically found in the SYSAUX schema. Option E is misleading as AWR snapshots primarily focus on performance metrics rather than extensive tracing and logging information.