nerdexam
Oracle

1Z0-052 · Question #177

Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

The correct answer is A. It can be increased up to the value of the SGA_MAX_SIZE parameter. B. Increasing the value of the SGA_TARGET parameter distributes the increased memory among all. SGA_TARGET controls the total SGA size under Automatic Shared Memory Management and can be dynamically adjusted within the upper bound set by SGA_MAX_SIZE.

Managing the Database Instance

Question

Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

Options

  • AIt can be increased up to the value of the SGA_MAX_SIZE parameter.
  • BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among all
  • CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and
  • DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic

How the community answered

(31 responses)
  • A
    77% (24)
  • C
    16% (5)
  • D
    6% (2)

Why each option

SGA_TARGET controls the total SGA size under Automatic Shared Memory Management and can be dynamically adjusted within the upper bound set by SGA_MAX_SIZE.

AIt can be increased up to the value of the SGA_MAX_SIZE parameter.Correct

SGA_TARGET is a dynamic parameter that can be increased online up to the value of SGA_MAX_SIZE, which serves as the hard upper limit for the total SGA. Attempting to set SGA_TARGET beyond SGA_MAX_SIZE will result in an error.

BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among allCorrect

When SGA_TARGET is increased, Oracle's Automatic Shared Memory Management (ASMM) automatically redistributes the additional memory across all autotuned SGA components such as the buffer cache, shared pool, large pool, Java pool, and streams pool.

CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and

Reducing SGA_TARGET only reclaims memory from autotuned components - manually sized components with explicit non-zero parameter values are not reduced by ASMM.

DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic

Increasing SGA_TARGET to the value of SGA_MAX_SIZE does not disable ASMM; automatic memory management remains active as long as SGA_TARGET is set to a non-zero value.

Concept tested: Automatic Shared Memory Management SGA_TARGET dynamic behavior

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/SGA_TARGET.html

Topics

#SGA_TARGET#SGA_MAX_SIZE#ASMM memory distribution#autotuned components

Community Discussion

No community discussion yet for this question.

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