Database Administration (MOSC)

MOSC Banner

Memory target in Oracle RAC

edited May 13, 2012 11:01PM in Database Administration (MOSC) 3 commentsAnswered
Hello All,
I created an Oracle RAC database 11.2.0.3. in DBCA I checked the enable AMM and specified my memory target.

But after I created my database I saw that my memory_target is 0 while sga_target and pga_aggregate_target were set.
Why this behavior?  is there any disadvantage if I enabled AMM?

Can I use the below steps?

ALTER SYSTEM SET MEMORY_TARGET=20G SCOPE=SPFILE sid=*;
ALTER SYSTEM SET PGA_AGGREGATE_TARGET=0 SCOPE=SPFILE sid=*;
ALTER SYSTEM SET SGA_TARGET=0 SCOPE=SPFILE sid=*;

restart the database.

Regards,



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