nerdexam
Oracle

1Z0-062 · Question #50

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

The correct answer is D. MMAN. Automatic Shared Memory Management relies on the MMAN background process to dynamically resize SGA components within the total SGA_TARGET limit.

Managing the Database Instance

Question

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

Options

  • APMON
  • BSMON
  • CMMNL
  • DMMAN
  • EMMON

How the community answered

(45 responses)
  • A
    2% (1)
  • C
    4% (2)
  • D
    93% (42)

Why each option

Automatic Shared Memory Management relies on the MMAN background process to dynamically resize SGA components within the total SGA_TARGET limit.

APMON

PMON (Process Monitor) cleans up failed user processes and releases resources, and has no role in SGA memory sizing.

BSMON

SMON (System Monitor) handles instance recovery, coalesces free space in tablespaces, and manages temporary segments, but does not manage shared memory sizing.

CMMNL

MMNL (Manageability Monitor Light) performs lightweight tasks such as flushing the Active Session History buffer to disk, not SGA component sizing.

DMMANCorrect

MMAN, the Memory Manager background process, is the dedicated Oracle process responsible for coordinating and implementing Automatic Shared Memory Management. It monitors memory component usage and automatically adjusts the sizes of the buffer cache, shared pool, large pool, Java pool, and streams pool based on workload demands within the configured SGA_TARGET limit.

EMMON

MMON (Manageability Monitor) performs manageability tasks such as taking AWR snapshots and issuing server alerts, not automatic memory resizing.

Concept tested: ASMM coordinator background process identification (MMAN)

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/memory-architecture.html

Topics

#Background Processes#Automatic Shared Memory Management (ASMM)#Memory Management

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice