Prev Question
Next 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?

A. LGWR

B. DBWR

C. CKPT

D. MMON

E. MMNL

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.
Reference: https://docs.oracle.com/cd/E11882_01/server.112/e40540/process.htm#CNCPT008

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *