This discussion is archived
13 Replies Latest reply: Mar 17, 2012 2:40 AM by dbthought RSS

sga_max_size & memory_max_target

dbthought Newbie
Currently Being Moderated
Hi All,

Could you please tell me ...

In oracle 11.1 If I want to set Memory Parameter

alter system set memory_max_target=2000M scope=spfile;
alter system set memory_target=2000M scope=spfile;

Do I need to set sga_max_size value ? or it will set automatically

As Per my knowledge

We need to Set following sga parameter to 0, if ASMM, or AMM set to ON.(By default oracle 11g using ASMM, or AMM set to ON)
alter system set sga_target=0 scope=spfile;
alter system set pga_aggregate_target=0 scope=spfile;

I am not sure about sga_max_size

Thanking in Advance



  • Correct Answers - 10 points
  • Helpful Answers - 5 points