1z0-062 Exam - Question 20

Question

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

Examice · Accepted Answer

The memory parameters shown indicate that `memory_target` is set to 5G and `memory_max_target` is set to 6G, with both `sga_target` and `sga_max_size` set to 0. This configuration means that Oracle will automatically manage both SGA (System Global Area) and PGA (Program Global Area) within the limits specified by `memory_target` and `memory_max_target`. Therefore, memory can be dynamically reallocated between the SGA and PGA as needed to meet the database's processing demands.

_gio_ · Answer

https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11201

JMAN1 · Answer

B is correct as _gio_ wrote.

racle Database can manage the SGA memory and instance PGA memory completely automatically. You designate only the total memory size to be used by the instance, and Oracle Database dynamically exchanges memory between the SGA and the instance PGA as needed to meet processing demands.

_Cobra_ · Answer

B is correct

1z0-062 Exam - Question 20

Discussion