Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

AMM and Memory_target after creating the database

Neo-bMay 14 2012 — edited May 14 2012

Hello All,

I created an Oracle RAC 11.2.0.3 database using dbca.
During the installation I enabled AMM.

but after creating my database I found that the memory_target is 0 while sga_target and pga_aggregate_target were set.

Why It was not set during the installation, knowing that I enabled AMM from dbca?
Can I use the below steps to enable AMM on RAC??

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

Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 11 2012

Added on May 14 2012

#general-database-discussions

5 comments

423 views