Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC
environment?
A.
The AWR includes time model statistics based on time usage for activities displayed In the
VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views.
B.
The AWR is controlled by the statistics_level initialization parameter and it must be set to
TYPICAL or BASIC
C.
The Manageability Monitor Processes (MMON) process gathers statistics every hour from
every instance and creates an AWR snapshot and stores it In the SGA.
D.
The MMON process gathers statistics from its’ own instance and kicks off statistics collection
form other instances every hour from other instances and creates an AWR snapshot which is
written to the sysaux tablespace.
Explanation:
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:
V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views
V$SESSTAT views
Activity
MMON (Memory Monitor) is a background process that gathers memory statistics (snapshots)
stores this information in the AWR (automatic workload repository). MMON is also responsible for
issuing alerts for metrics that exceed their thresholds.
Oracle Database Performance Tuning Guide
A is right. AWR is using sys and sess time model
B is wrong. typical or all, not basic
C is wrong. not just SGA (memory)
D is right. stored in sysaux tablespace
So A.D. are correct