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!

What if I set MEMORY_MAX_TARGET and SGA_MAX_SIZE both?

CSM.DBANov 15 2012 — edited Nov 22 2012

I have set MEMORY_MAX_TARGET to something like 1G and SGA_MAX_SIZE to 500M. How would Oracle treat this? the 500M is treated as minimum SGA and SGA could grow till 1G-PGA??

What if i set MEMORY_MAX_TARGET= SGA_MAX_SIZE = 1G ??

Thanks,
CSM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2012

Added on Nov 15 2012

#general-database-discussions

14 comments

3,542 views