Oracle Database 12c: Installation and Administration — Question 58

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

Answer options

• A. All AWR tables belong to the SYSTEM schema.
• B. The AWR data is stored in memory and in the database.
• C. The snapshots collected by AWR are used by the self-tuning components in the database
• D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E. AWR contains system wide tracing and logging information.

Correct answer: B, C, D

Explanation

Option B is correct because AWR data is indeed stored in both memory and the database. Option C is also correct as the snapshots collected by AWR are utilized by self-tuning components. Option D is correct since AWR does compute time model statistics, while options A and E are incorrect as AWR tables do not belong to the SYSTEM schema and it does not specifically contain system-wide tracing and logging information.