0
Recently I have installed Oracle 11g (11.2.0.1.0) on my Windows 7 desktop having 1GB RAM, and while installation I have allocated 512 MB RAM to Oracle which causes high memory utilization and reduction is PC performance while running Oracle.
As I am using Oracle 11g for learning purpose, I want to shrink memory from 512 to 256 MB I tried to do it from enterprise manager > Memory advisors, changing following parameter
OLD:
Total Memory Size = 500 MB
Maximum Memory Size = 500 MB
New:
Total Memory Size = 256 MB
Maximum Memory Size = 256 MB
Showing the following error:
"memoryMaxTarget - Maximum Memory Size cannot be less than Maximum SGA Size."
Can anybody tell me how to shrink the memory using enterprise Manager and using SQL*Pluse?
Most memory is super cheap, can I ask why you just don't add another real 1gb of memory? – cybernard – 2013-07-14T03:22:12.703
If it says it can not be less than the SGA size you need to find and reduce that first. – cybernard – 2013-07-14T03:22:57.643
that the question how to reduce SGA size!!!! – Ganesh Dake – 2013-07-14T07:06:14.510