Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC environment?

Which two statements are true regarding the Automatic Workload Repository (AWR) In a
RAC environment?

Which two statements are true regarding the Automatic Workload Repository (AWR) In a
RAC environment?

A.
The AWR is controlled by the statistics_level initialization parameter and it must be set to
TYPICAL or BASIC

B.
The Manageability Monitor Processes (MMON) process gathers statistics every hour
from every instance and creates an AWR snapshot and stores it In the SGA.

C.
The AWR includes time model statistics based on time usage for activities displayed In
the VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views.

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *