Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC environment?

The correct answer is A. The AWR includes time model statistics based on time usage for activities displayed In the D. The MMON process gathers statistics from its' own instance and kicks off statistics collection form. The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views. The statistics…

Install and Administer Oracle RAC

Question

Options

AThe AWR includes time model statistics based on time usage for activities displayed In the
BThe AWR is controlled by the statistics_level initialization parameter and it must be set to
CThe Manageability Monitor Processes (MMON) process gathers statistics every hour from every
DThe MMON process gathers statistics from its' own instance and kicks off statistics collection form

How the community answered

(40 responses)

A
85% (34)
B
5% (2)
C
10% (4)

Explanation

The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views. The statistics collected and processed by AWR include: V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views MMON (Memory Monitor) is a background process that gathers memory statistics (snapshots) stores this information in the AWR (automatic workload repository). MMON is also responsible for issuing alerts for metrics that exceed their thresholds. Oracle Database Performance Tuning Guide

Topics

#AWR in RAC#MMON process#statistics collection#time model statistics

Community Discussion

No community discussion yet for this question.

Full 1Z0-058 Practice