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

Question

Options

• ATaking an AWR snapshot in a RAC database captures data from all instances that have the
• BTaking an AWR snapshot in a RAC database captures data from the local instance only.
• CData captured by an AWR is aggregated across all instances before being stored in the database.
• DThe awr_snapshot_time_offset parameter specifies the number of seconds each instance waits
• EAWR snapshots are created when control_management_pack_access is set to "none"

• A
  77% (40)
• B
  8% (4)
• E
  15% (8)

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. https://docs.oracle.com/cloud/latest/db112/REFRN/initparams018.htm#REFRN10325

No community discussion yet for this question.