1Z0-052 · Question #122
Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
The correct answer is C. The snapshots collected by the AWR are accessible through data dictionary views D. The snapshots collected by the AWR are used by self-tuning components in the database. AWR snapshots are stored under the SYS schema in the SYSAUX tablespace, accessible through DBA_HIST_* views, and serve as the primary data source for Oracle self-tuning advisors such as ADDM and the SQL Tuning Advisor.
Question
Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)
Options
- AAll AWR tables belong to the SYSTEM schema
- BThe AWR contains systemwide tracing and logging information
- CThe snapshots collected by the AWR are accessible through data dictionary views
- DThe snapshots collected by the AWR are used by self-tuning components in the database
How the community answered
(29 responses)- A3% (1)
- B3% (1)
- C93% (27)
Why each option
AWR snapshots are stored under the SYS schema in the SYSAUX tablespace, accessible through DBA_HIST_* views, and serve as the primary data source for Oracle self-tuning advisors such as ADDM and the SQL Tuning Advisor.
AWR tables belong to the SYS schema and reside in the SYSAUX tablespace, not the SYSTEM schema; confusing the SYS and SYSTEM schemas is a common misconception.
AWR captures performance statistics such as wait events, SQL metrics, and system statistics; systemwide tracing and logging are handled separately by Oracle trace files and the alert log, not AWR.
AWR snapshot data is exposed through the DBA_HIST_* family of data dictionary views (such as DBA_HIST_SNAPSHOT and DBA_HIST_SQLSTAT), allowing DBAs to query historical performance metrics directly.
Self-tuning components including ADDM, the SQL Tuning Advisor, and the Segment Advisor read AWR snapshots as their primary input to generate automated performance analysis and recommendations.
Concept tested: AWR schema ownership, DBA_HIST views, and self-tuning integration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/DBA_HIST_SNAPSHOT.html
Topics
Community Discussion
No community discussion yet for this question.