Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Recently i have installed Oracle 11g ( 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

New :

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?

share|improve this question
Most memory is super cheap, can I ask why you just don't add another real 1gb of memory? – cybernard Jul 14 '13 at 3:22
If it says it can not be less than the SGA size you need to find and reduce that first. – cybernard Jul 14 '13 at 3:22
that the question how to reduce SGA size!!!! – Ganesh Dake Jul 14 '13 at 7:06

Try this:

(Adjust your scope accordingly)

alter system set sga_max_size=256M scope=spfile;


shu immediate


show parameter sga

share|improve this answer
FYI: A reduction in RAM for oracle will probably hurt the database performance. – cybernard Jul 14 '13 at 15:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.