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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.