Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer 1

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
add comment

Your Answer

 
discard

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.