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

Question

Options

• AAll AWR tables belong to the SYSTEM schema.
• BThe AWR data is stored in memory and in t he database.
• CThe snapshots collected by AWR are used by the self-tuning components in the database
• DAWR computes time model statistics based on time usage for activities, which are displayed in
• EAWR contains system wide tracing and logging information.

• A
  11% (5)
• B
  84% (37)
• E
  5% (2)

Explanation

AWR stores performance statistics both in memory (captured in the SGA) and persistently in the database (in the SYSAUX tablespace via snapshots), making B correct. Those snapshots are the foundation for self-tuning components like ADDM and the various advisors (SQL Tuning, Memory, etc.), confirming C. AWR also computes time model statistics - breaking down DB time into CPU time, I/O wait, concurrency wait, etc. - which appear in AWR reports, making D correct.

A is wrong because AWR tables belong to the SYS schema and reside in the SYSAUX tablespace, not the SYSTEM schema - a common trap question. E is wrong because AWR tracks performance workload statistics, not tracing/logging; system-wide tracing belongs to facilities like Unified Tracing (SQL Trace, 10046 events) and alert logs.

Memory tip: Think of AWR as a performance historian - it Snapshots data, Stores it in SYSAUX (under SYS), and Supplies self-tuning components with time-model data. The three S's map directly to B, C, and D.

No community discussion yet for this question.