nerdexam
Oracle

1Z0-060 · Question #199

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

The correct answer is B. PGA size can grow automatically beyond 500 MB. Under Automatic Memory Management (MEMORY_TARGET set), PGA_AGGREGATE_TARGET is a soft target, not a hard cap, so PGA can grow beyond 500 MB.

New Features for Database Infrastructure and Architecture

Question

Examine the memory-related parameters of an Oracle database instance:

Which statement is true?

Exhibit

1Z0-060 question #199 exhibit

Options

  • AThe value of the memory_target parameter cannot be changed dynamically.
  • BPGA size can grow automatically beyond 500 MB.
  • COnly the components of SGA are managed automatically.
  • DMemory is dynamically re-allocated between SGA and PGA as needed.

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    93% (28)
  • C
    3% (1)

Why each option

Under Automatic Memory Management (MEMORY_TARGET set), PGA_AGGREGATE_TARGET is a soft target, not a hard cap, so PGA can grow beyond 500 MB.

AThe value of the memory_target parameter cannot be changed dynamically.

MEMORY_TARGET is a dynamic parameter and can be altered with ALTER SYSTEM without restarting the database instance.

BPGA size can grow automatically beyond 500 MB.Correct

When MEMORY_TARGET is configured, Oracle enables Automatic Memory Management and treats PGA_AGGREGATE_TARGET as a tuning goal rather than an absolute ceiling. Oracle can allocate additional memory to PGA components beyond 500 MB by reclaiming it from SGA when workload demands require it, making the PGA effectively unbounded up to MEMORY_MAX_TARGET.

COnly the components of SGA are managed automatically.

With MEMORY_TARGET enabled (AMM), both SGA components and PGA are managed automatically together - not SGA alone, which describes ASMM (SGA_TARGET without MEMORY_TARGET).

DMemory is dynamically re-allocated between SGA and PGA as needed.

While dynamic reallocation between SGA and PGA does occur under AMM, this statement alone is less precisely correct in the context of the shown parameters than option B, which specifically addresses the PGA_AGGREGATE_TARGET boundary behavior.

Concept tested: Oracle Automatic Memory Management and PGA_AGGREGATE_TARGET as soft limit

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

Topics

#Automatic Memory Management#MEMORY_TARGET#PGA_AGGREGATE_TARGET#SGA

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice