Oracle Database 12c: RAC Administration — Question 5

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?

Answer options

• A. Taking an AWR snapshot in a RAC database captures data from all instances that have the database opened.
• B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
• C. Data captured by an AWR is aggregated across all instances before being stored in the database.
• D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after the top of the hour before taking its AWR snapshot.
• E. AWR snapshots are created when control_management_pack_access is set to "none"

Correct answer: A, D, E

Explanation

Option A is correct because an AWR snapshot in a RAC environment indeed gathers data from all instances that are active. Option B is incorrect as it suggests that only the local instance's data is captured, which is not the case. Option C is false because AWR data is not aggregated before storage; it is stored separately for each instance. Option D is accurate, and option E is also correct because AWR snapshots are not created when the management pack access is set to 'none'.