Examine the memory-related parameters set in the SPFILE of an Oracle database: Which
statement is true?
A.
Only SGA components are sized automaticallyB. 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.
The answer is D
D is not a correct answer. You can dynamically change this parameter. I think C is also wrong – Oracle will allocate 500MB for PGA but can go beyond that if needed. A looks fine but I cant see B here…
Correct answer is:B
Whem Memory Target is set, the given values for SGA and PGA will be minimum values. so, memory is dynamically allocated between SGA and PGA.
pga_agreggate_target isn’t a limit. pga_aggregate_limit is. When limit is reached Oracle start to kill sessions with the most space allocated
When memory_target is set, activates Automatic Memory Management (AMM). AMM dinamically reallocate memory between SGA and PGA. SGA components are also dinamically reallocated because ASMM is activated when AMM is
So correct is B