Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to increase the size of memory_target parameter in 32bit windows environment

2935323Sep 27 2016 — edited Sep 28 2016

Hello

I am running Oracle 11g in following environment :

OS: Windows 2008 (32 bit)

RAM: 16GB

I like to set memory_target 10GB. I have tried as follows:

ALTER SYSTEM SET MEMORY_MAX_TARGET=10G SCOPE=SPFILE;

ALTER SYSTEM SET MEMORY_TARGET=10G SCOPE=SPFILE;

SHUTDOWN IMMEDIATE;

STARTUP;

But database failed to startup by following error:

ORA-27102: out of memory

Then I startup database from pfile setting 1600M for MEMORY_MAX_TARGET and MEMORY_TARGET .

Now my question, is there any way to set MEMORY_TARGET=10G in 32bit windows environment?

Thanks

Suman

This post has been answered by JohnWatson2 on Sep 27 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2016
Added on Sep 27 2016
10 comments
922 views