1Z0-062 · Question #300
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
The correct answer is A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based B. AWR data is stored in memory and in a database. D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is. Automatic Workload Repository (AWR) captures system statistics and performance data, which is gathered by the MMON process and stored in the database.
Question
Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)
Options
- AAn AWR snapshot shows the SQL statements that are producing the highest load on the system, based
- BAWR data is stored in memory and in a database.
- CAll AWR tables belong to the SYSTEM schema.
- DThe manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is
- EAn AWR snapshot contains system-wide tracing and logging information.
How the community answered
(34 responses)- A85% (29)
- C12% (4)
- E3% (1)
Why each option
Automatic Workload Repository (AWR) captures system statistics and performance data, which is gathered by the MMON process and stored in the database.
AWR snapshots collect comprehensive system statistics and wait events, which are then used to identify the top SQL statements consuming the most resources and contributing to system load, aiding in performance tuning.
AWR data is initially collected and aggregated in memory by various background processes, and then it is periodically written and stored persistently in dedicated tables within the SYSAUX tablespace of the database.
AWR tables and views belong to the SYS schema, not the SYSTEM schema, and are stored in the SYSAUX tablespace.
The Manageability Monitor (MMON) background process is a key component of Oracle's self-management framework; it is responsible for gathering statistics, creating AWR snapshots at regular intervals, and performing other automatic management tasks.
An AWR snapshot contains aggregated performance metrics, statistics, and wait event data over an interval, not detailed system-wide tracing and logging information, which is typically found in trace files or diagnostic logs.
Concept tested: Automatic Workload Repository (AWR) characteristics
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgdba/automatic-workload-repository.html#GUID-7A7DF004-9E35-4E57-B15E-D2484AE401F5
Topics
Community Discussion
No community discussion yet for this question.