Examine the memory-related parameters set in the SPFILE of an Oracle database:
memory_max_target–6G
memory_target=5G
pga_aggregate_target=500M
sga_max_size=0
sga_target=0
Which statement is true?
A.
Only SGA components are sized automatically
B.
Memory is dynamically re-allocated between the SGA and PGA as needed.
C.
The size of the PGA cannot grow automatically beyond 500 MB.
D.
The value of the MEMORY_TARGET parameter cannot be changed dynamically.
I think C is wrong.
Taken from here:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm#ADMIN11201
“You can omit the statements that set these parameter values to zero and leave either or both of the values as positive numbers. In this case, the values act as minimum values for the sizes of the SGA or instance PGA.”
So it’s not the maximum value of the PGA but the minimum value. So it can in fact grow automatically beyond 500mb, but now below.
I think answer B is correct.
memory_target=5G –> AMM enabled
so answer is B
Answer is B:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm#ADMIN11011
The instance then tunes to the target memory size, redistributing memory as needed between the system global area (SGA) and the instance program global area (instance PGA). Because the target memory initialization parameter is dynamic, you can change the target memory size at any time without restarting the database.
Sorry the Answer B will be correct if the AMM activated.
the Correct Answer is C, because it is the main function of the parameter: pga_aggregate_target
Correct is B. C is wrong.
See 12c documentation: With MEMORY_TARGET set, the SGA_TARGET setting becomes the minimum size of the SGA and the PGA_AGGREGATE_TARGET setting becomes the minimum size of the instance PGA.
https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11200
agree.. B is correct.