Link to home
Start Free TrialLog in
Avatar of USAISR
USAISR

asked on

increased my os ram to 16G, how do i increase the memory to oracle

I am running windows server 2003 enterprise edition and have up'ed my RAM to 16G (showing on my computer properties as 16G)
how do i allocate some of this to oracle 11g AMM?

i have  tried to increase using the;
ALTER SYSTEM SET MEMORY_MAX_TARGET=6G SCOPE=SPFILE;
ALTER SYSTEM SET MEMORY_TARGET=5G SCOPE=SPFILE;
ALTER SYSTEM SET PGA_AGGREGATE_TARGET=0 SCOPE=SPFILE;
ALTER SYSTEM SET SGA_TARGET=0 SCOPE=SPFILE;

and also changing in PFILE(init.ORA) with no luck.

keep getting the out of memory error.
ASKER CERTIFIED SOLUTION
Avatar of asavener
asavener
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial