Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently…

The correct answer is D. MMON. The manageability monitor process (MMON) performs many tasks related to the Automatic Workload Repository (AWR). For example, MMON writes when a metric violates its threshold value, taking snapshots, and capturing statistics value for recently modified SQL objects…

Automatic Performance Tuning Features

Question

Which background process performs Automatic Workload Repository (AWR) tasks such as writing when a metric violates its threshold value, taking snapshots, and capturing statistics for recently modified SQL objects?

Options

ALGWR
BDBWR
CCKPT
DMMON
EMMNL

How the community answered

(25 responses)

A
8% (2)
B
4% (1)
C
16% (4)
D
72% (18)

Explanation

The manageability monitor process (MMON) performs many tasks related to the Automatic Workload Repository (AWR). For example, MMON writes when a metric violates its threshold value, taking snapshots, and capturing statistics value for recently modified SQL objects. https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT008

Topics

#MMON#AWR#background processes#snapshots

Community Discussion

No community discussion yet for this question.

Full 1Z0-417 Practice