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 V$SYS_TIME_MODEL and V$SESS_TIME_MODEL 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.
A,C
A & D are correct.
why ?
Sorry, didn’t see your question.
… “The statistics collected and processed by AWR include:
…
Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views”…
This comes from 10g and didn’t changed until 11.2. I’m reviewing docs for 12c. (http://docs.oracle.com/cd/B14117_01/server.101/b10752/autostat.htm).
So, A, D are correct answers.
By default, the MMON process gathers statistics every hour and creates an AWR snapshot (see “Manageability Monitor Processes (MMON and MMNL)”). A snapshot is a set of performance statistics captured at a specific time. The database writes snapshots to the SYSAUX tablespace. AWR manages snapshot space, purging older snapshots according to a configurable snapshot retention policy.
http://docs.oracle.com/cd/E11882_01/server.112/e25789/cncptdba.htm