nerdexam
Oracle

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.

Managing Performance

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)
  • A
    85% (29)
  • C
    12% (4)
  • E
    3% (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.

AAn AWR snapshot shows the SQL statements that are producing the highest load on the system, basedCorrect

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.

BAWR data is stored in memory and in a database.Correct

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.

CAll AWR tables belong to the SYSTEM schema.

AWR tables and views belong to the SYS schema, not the SYSTEM schema, and are stored in the SYSAUX tablespace.

DThe manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that isCorrect

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.

EAn AWR snapshot contains system-wide tracing and logging information.

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

#AWR#AWR snapshot#MMON process#performance statistics

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice