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!

MEMORY_TARGET AND SGA_MAX_SIZE PARAMETERS

CESARDBAIBMJun 28 2012 — edited Oct 1 2013

Hi all,

I was just wondering how is the relationship between MEMORY_TARGET and SGA_MAX_SIZE parameters, if exists any at all.

I set my memory parameters as:
# Enable AMM
MEMORY_MAX_SIZE=10G
MEMORY_TARGET=4G
# Disable ASMM
SGA_TARGET=0
SGA_MAX_SIZE=0

So I bounce my instances and when I checked the parameter SGA_MAX_SIZE, Oracle automatically set a value of 2456M to it:
sga_max_size big integer 2456M
sga_target big integer 0

Reading MOS ID 443746.1, there is no clear mention about this relationship. It seems that Oracle automatically set SGA_MAX_SIZE as 60% of MEMORY_TARGET.

In am running Oracle 11gR2 (11.2.0.2.3) under Red Hat Linux. Appreciate any input on that.

Thank you in advance,
Cesar

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2013

Added on Jun 28 2012

#general-database-discussions

10 comments

48,388 views