Database Administration (MOSC)

MOSC Banner

Automatic memory managent what if I set the sga_target to a value higher than zero?

edited Oct 13, 2016 5:00AM in Database Administration (MOSC) 3 commentsAnswered

This to enable automatic memory management ;I need to understand how it works?

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=1G SCOPE=SPFILE;

ALTER SYSTEM SET SGA_TARGET=1G SCOPE=SPFILE;

-- Restart instance.

SHUTDOWN IMMEDIATE;

STARTUP;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center