nerdexam
Oracle

1Z0-062 · Question #239

You set the following parameters in the parameter file and restart the database instance: Which two statements are true?

The correct answer is A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. C. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.. If MEMORY_TARGET is set to a non-zero value, MEMORY_MAX_TARGET is automatically adjusted to match it, but if both are unset or zero, AMM is disabled and MEMORY_MAX_TARGET remains zero.

Managing the Database Instance

Question

You set the following parameters in the parameter file and restart the database instance:

Which two statements are true?

Options

  • AThe MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
  • BThe PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to
  • CThe value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.
  • DThe lower limits of thePGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to
  • EThe instance does not start up because Automatic Memory Management (AMM) is enabled but

How the community answered

(28 responses)
  • A
    79% (22)
  • B
    4% (1)
  • D
    4% (1)
  • E
    14% (4)

Why each option

If `MEMORY_TARGET` is set to a non-zero value, `MEMORY_MAX_TARGET` is automatically adjusted to match it, but if both are unset or zero, AMM is disabled and `MEMORY_MAX_TARGET` remains zero.

AThe MEMORY_MAX_TARGET parameter is automatically set to 500 MB.Correct

If `MEMORY_TARGET` is configured to 500 MB and `MEMORY_MAX_TARGET` is not explicitly set in the parameter file, Oracle automatically sets `MEMORY_MAX_TARGET` to match `MEMORY_TARGET` during instance startup.

BThe PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to

`PGA_AGGREGATE_TARGET` and `SGA_TARGET` are typically set when AMM is not fully enabled and are not automatically set to 0 when AMM is in use unless specifically configured as such.

CThe value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.Correct

If `MEMORY_TARGET` is not set or set to 0, and `MEMORY_MAX_TARGET` is also not set or set to 0, Automatic Memory Management (AMM) is disabled, and the `MEMORY_MAX_TARGET` value effectively remains zero for the instance.

DThe lower limits of thePGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to

`PGA_AGGREGATE_TARGET` and `SGA_TARGET` define memory targets, not lower limits, for their respective areas when AMM is not fully enabled.

EThe instance does not start up because Automatic Memory Management (AMM) is enabled but

The instance will start up, as setting `MEMORY_TARGET` enables AMM, and if `MEMORY_MAX_TARGET` is not explicitly set or set to 0, it defaults to `MEMORY_TARGET` value, which does not prevent startup.

Concept tested: Oracle Automatic Memory Management (AMM) parameters

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-E53B0282-3B45-4299-8D7E-D96F3430A370

Topics

#memory management#SGA_TARGET#PGA_AGGREGATE_TARGET#AMM

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice