1Z0-062 · Question #30
Which three statements are true about Automatic Workload Repository (AWR)?
The correct answer is B. The AWR data is stored in memory and in the database. C. The snapshots collected by AWR are used by the self-tuning components in the database D. AWR computes time model statistics based on time usage for activities, which are displayed in. AWR stores snapshot data both in memory and in the SYSAUX tablespace, drives self-tuning components, and computes time model statistics - but does not own its tables under SYSTEM and does not manage tracing or logging.
Question
Which three statements are true about Automatic Workload Repository (AWR)?
Options
- AAll AWR tables belong to the SYSTEM schema.
- BThe AWR data is stored in memory and in the database.
- CThe snapshots collected by AWR are used by the self-tuning components in the database
- DAWR computes time model statistics based on time usage for activities, which are displayed in
- EAWR contains system wide tracing and logging information.
How the community answered
(46 responses)- A4% (2)
- B89% (41)
- E7% (3)
Why each option
AWR stores snapshot data both in memory and in the SYSAUX tablespace, drives self-tuning components, and computes time model statistics - but does not own its tables under SYSTEM and does not manage tracing or logging.
AWR tables are owned by SYS and stored in the SYSAUX tablespace, not in the SYSTEM schema.
AWR maintains a recent-statistics buffer in the SGA and periodically flushes complete snapshots to persistent tables in the SYSAUX tablespace, giving both in-memory and on-disk access to performance data. This dual storage supports both real-time monitoring and long-term trend analysis.
ADDM, Automatic Memory Management, and Automatic Optimizer Statistics Collection all consume AWR snapshots as their primary input for identifying bottlenecks and making tuning adjustments. Without AWR snapshots these self-tuning advisors cannot function.
AWR computes time model statistics that partition database time into categories such as DB CPU, SQL execute elapsed time, and parse time, surfaced in views like V$SYS_TIME_MODEL and included in every AWR report. These statistics are the foundation for workload characterization in Oracle performance analysis.
System-wide tracing and logging is handled by the Automatic Diagnostic Repository (ADR) via alert logs and trace files, which is a separate subsystem from AWR.
Concept tested: Oracle AWR architecture, storage, and self-tuning integration
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/gathering-database-statistics.html
Topics
Community Discussion
No community discussion yet for this question.