Which three statements are true about Automatic Workload Repository (AWR)?
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.
Explanation:
(http://docs.oracle.com/cd/B28359_01/server.111/b28274/autostat.htm#PFGRF02601):
5.2 Overview of the Automatic Workload Repository
The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for
problem detection and self-tuning purposes. This data is both in memory and stored in the database. The
gathered data can be displayed in both reports and views.
The statistics collected and processed by AWR include:
Object statistics that determine both access and usage statistics of database segments Time model statistics
based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views