SID3 wrote:Oracle won't let you set the reverse scenario.
Ok. Thanks for your clarification. Below are definitions from Oracle User Gudies
SGA_MAX_SIZE : This is the maximum size of the SGA for an given instance.
SGA_TARGET: This is the total size of SGA.
Now if we consider your defintion does this means that SGA_TARGET should always be less than SGA_MAX_SIZE? What could be the adverse effect in the reverse scenario?
Thanks in advance.