Recently i have installed Oracle 11g (220.127.116.11.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
Total Memory Size = 500 MB
Maximum Memory Size = 500 MB
Total Memory Size = 256 MB
Maximum Memory Size = 256 MB
show 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?