I have a general question related to Automatic Memory management in Oracle 11g.
Is there any upper limit for SGA to grow, if Memory_Target is set?
If SGA Max Size is set equal to Memory Target
Thanks & Regards,
Have to see and confirm it but I believe, if you have set the SGA_TARGET and SGA_MAX_SIZE, you would be having the max of SGA allowed till SGA_MAX_SIZE only. AMM would control the PGA allocations.