Home » Oracle » 1z0-068 » Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
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: ACD
Explanation/Reference:
Explanation:
AWR snapshots are collect at database level.
Oracle extends the AWR tool for RAC databases by adding the possibility to generate snapshots reports against the whole cluster database, some database instances of the cluster database, a specific database instance of the cluster database, statistics for a specific select query.
D: AWR_SNAPSHOT_TIME_OFFSET specifies an offset for the AWR snapshot start time. AWR snapshots normally start at the top of the hour (12:00, 1:00, 2:00, and so on). This parameter allows DBAs to specify an offset for the AWR snapshot start time.
Incorrect Answers:
E: CONTROL_MANAGEMENT_PACK_ACCESS specifies which of the Server Manageability Packs should be active. The following packs are available:
The DIAGNOSTIC pack includes AWR, ADDM, and so on.
The TUNING pack includes SQL Tuning Advisor, SQLAccess Advisor, and so on.
The NONE value means that both packs are not available.
References: https://docs.oracle.com/cloud/latest/db112/REFRN/initparams018.htm#REFRN10325
http://www.oracle-class.com/?p=2409
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
ACD is correct,
when control_management_pack_access is set to “none”, AWR will be disabled.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/CONTROL_MANAGEMENT_PACK_ACCESS.html#GUID-A5CA11BA-AE1F-4A2E-9C59-A98BA1F4E5C2
correct answer ade
My Assumptions are C is wrong and Correct answer should be ADE, control management will not disable the snapshot but only metric collections)