AMM Configuration

Oracle

ALTER SYSTEM SET MEMORY_MAX_TARGET=20G SCOPE=SPFILE sid=’*’;

ALTER SYSTEM SET MEMORY_TARGET=18G SCOPE=SPFILE sid=’*’;

Assuming our required setting was 5G, we might issue the following statements.

CONN / AS SYSDBA
— Set the static parameter. Leave some room for possible future growth without restart.
ALTER SYSTEM SET MEMORY_MAX_TARGET=6G SCOPE=SPFILE;

— Set the dynamic parameters. Assuming Oracle has full control.
ALTER SYSTEM SET MEMORY_TARGET=5G SCOPE=SPFILE;
ALTER SYSTEM SET PGA_AGGREGATE_TARGET=0 SCOPE=SPFILE sid=’‘; ALTER SYSTEM SET SGA_TARGET=0 SCOPE=SPFILE sid=’‘;

— Restart instance.
SHUTDOWN IMMEDIATE;
STARTUP;
Once the database is restarted the MEMORY_TARGET parameter can be amended as required without an instance restart.

ALTER SYSTEM SET MEMORY_TARGET=4G SCOPE=SPFILE;

Leave a Reply

Your email address will not be published. Required fields are marked *