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"
Suggested Answer:ADE🗳️
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
When the parameter CONTROL_MANAGMENT_PACK_ACCESS is set to NONE, it is expected behavior that AWR snapshots will continue to be generated. However, metrics will not be generated.
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=270735212666178&parent=EXTERNAL_SEARCH&sourceId=REFERENCE&id=1437539.1&_afrWindowMode=0&_adf.ctrl-state=15qcd6mr36_4
ACD
The NONE value means that both packs are not available.
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
bestsalman
5 months, 1 week agoexams01
1 year agoYoones
1 year, 3 months agogon20
3 years ago