1Z0-052 · Question #99
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows: Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing alerts when the…
The correct answer is D. Manageability Monitor process (MMON). The Manageability Monitor process (MMON) is the Oracle background process responsible for monitoring server metrics and issuing alerts when configured thresholds such as tablespace usage are crossed.
Question
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:
Warning (%): 90 Critical (%): 95 Which background process is responsible for issuing alerts when the threshold is crossed?
Options
- ASystem monitor (SMON)
- BProcess monitor (PMON)
- CMemory manager process (MMAN)
- DManageability Monitor process (MMON)
How the community answered
(47 responses)- A9% (4)
- B2% (1)
- C2% (1)
- D87% (41)
Why each option
The Manageability Monitor process (MMON) is the Oracle background process responsible for monitoring server metrics and issuing alerts when configured thresholds such as tablespace usage are crossed.
SMON handles instance recovery after a crash, coalesces free space in dictionary-managed tablespaces, and cleans up temporary segments - it has no role in threshold alerting.
PMON cleans up failed user processes and releases their resources and locks; it does not monitor tablespace metrics or issue threshold alerts.
MMAN manages Automatic Memory Management by dynamically resizing SGA components; it is not involved in tablespace metric evaluation or alert generation.
MMON is the background process that periodically captures AWR snapshots and evaluates server-generated metric thresholds; when a metric like tablespace usage crosses a warning or critical threshold, MMON generates the corresponding alert in the DBA_OUTSTANDING_ALERTS view and the alert log.
Concept tested: MMON background process and tablespace threshold alerts
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-space-for-schema-objects.html#GUID-9B7F1B5A-0D4A-4C8C-8B0E-6D4F6E0E8E8E
Topics
Community Discussion
No community discussion yet for this question.