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!

SGA and PGA size

Neo-bMar 28 2011 — edited Mar 29 2011

Hello All,

I have a question.
What is the best criteria to set the size of the SGA and PGA size in oracle 10g? and the memory_target size in oracle 11g ?
Is it related to the size of data ? what is the criteria/factors in which it affect setting the size of the SGA, PGA (10g) and memory_target (11g)?

Regards,

This post has been answered by Lubiez Jean-Valentin on Mar 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 26 2011

Added on Mar 28 2011

#general-database-discussions

8 comments

30,622 views