nerdexam
Oracle

1Z0-062 · Question #165

Examine the memory-related parameters set in the SPFILE of an Oracle database: Which statement is true?

The correct answer is B. Memory is dynamically re-allocated between the SGA and PGA as needed. When MEMORY_TARGET is set, Oracle uses Automatic Memory Management (AMM), which dynamically shifts memory between the SGA and PGA based on workload demand.

Managing the Database Instance

Question

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

Options

  • AOnly SGA components are sized automatically-
  • BMemory is dynamically re-allocated between the SGA and PGA as needed.
  • CThe size of the PGA cannot grow automatically beyond 500 MB.
  • DThe value of the MEMORY_TARGET parameter cannot be changed dynamically.

How the community answered

(34 responses)
  • A
    3% (1)
  • B
    91% (31)
  • D
    6% (2)

Why each option

When MEMORY_TARGET is set, Oracle uses Automatic Memory Management (AMM), which dynamically shifts memory between the SGA and PGA based on workload demand.

AOnly SGA components are sized automatically-

When MEMORY_TARGET is set, both SGA and PGA components are managed automatically, not just SGA; Automatic Shared Memory Management (ASMM) via SGA_TARGET manages only the SGA.

BMemory is dynamically re-allocated between the SGA and PGA as needed.Correct

With AMM enabled via MEMORY_TARGET, Oracle's memory manager continuously monitors demand for both SGA and PGA allocations and automatically transfers memory between them to optimize performance. This means neither component is statically bounded - Oracle can shrink SGA to enlarge the PGA or vice versa as workload patterns change, all within the total MEMORY_TARGET ceiling.

CThe size of the PGA cannot grow automatically beyond 500 MB.

Under AMM, the PGA is not capped at a fixed value; it can grow dynamically up to the overall MEMORY_TARGET limit based on demand.

DThe value of the MEMORY_TARGET parameter cannot be changed dynamically.

MEMORY_TARGET is a dynamic parameter and can be changed at the instance level using ALTER SYSTEM without requiring a database restart.

Concept tested: Oracle Automatic Memory Management with MEMORY_TARGET

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html

Topics

#Automatic Memory Management (AMM)#SGA#PGA#MEMORY_TARGET

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-062 Practice