Skip to Main Content
Forums

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!

Am I understanding SGA_TARGET and SGA_MAX_SIZE correctly?

raindogJun 23 2011 — edited Jun 23 2011
Let's say I set SGA_MAX_SIZE to 1024MB and SGA_TARGET to 512MB.

As I understand it, this means that the total SGA size will never exceed 1024MB (that's the "hard cap"). Oracle will try to keep things around 512MB, but may burst up to 1024MB as needed.

Is that correct? Otherwise, I don't see the point of SGA_MAX_SIZE vs. SGA_TARGET.

BTW...I know MEMORY_TARGET and MEMORY_MAX_TARGET are the new 11g params, but Oracle ships XE with those turned off and the 10g SGA_* params and PGA_AGGREGATE_TARGET set...?
This post has been answered by unknown-698157 on Jun 23 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 21 2011
Added on Jun 23 2011
#general-database-discussions
3 comments
1,416 views