Thanks for the question, sanjiv.
Asked: April 22, 2017 - 7:25 am UTC
Last updated: April 22, 2017 - 1:51 pm UTC
Version: 11.2.0
Viewed 1000+ times
You Asked
Greetings Sir,
For an example, i have total ram of 2GB. I have disabled the AMM ie memory_target=0. This allows me to resize the sga parameters.
I just tried to set the sga_max_size=5G and sga_target=4G. I restarted the instance. It goes normally.
My question is, this configuration should have some memory exceeded errors right? Or am i missing some theories behind it?
With Regards,
Sanjiv Ranjit
and Connor said...
It just means that a chunk of your sga will ultimately end up as being swapped out to disk. Obviously, that would be a bad idea, but as long as the total *addressable* memory (real RAM + disk) is greater than your SGA, your database will "run"...just very badly :-)
Is this answer out of date? If it is, please let us know via a Comment