Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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 (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

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;

ALTER SYSTEM SET MEMORY_MAX_TARGET = 256M SCOPE = SPFILE;

shu immediate

startup

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .