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!

PGA and SGA_MAX_SIZE and SGA_TARGET

pjsiong-JavaNetMay 12 2010 — edited May 18 2010

Hi,
I have an oracle instance with SGA_MAX_SIZE=1G and SGA_TAGET=512m,
PGA_AGGREATE_TARGET=200m,
recently I found some error in alert that some process have memory allocation error,
anyone can tell me, what is the relationship between PGA and SGA_MAX_SIZE and SGA_TARGET?
I know that SGA_TARGET cannot be greater than SGA_MAX_SIZE, but for PGA, where it;s memory allocated from?
Is that true, PGA allocated +SGA_TARGET must <=SGA_MAX_SIZE?

Thanks

Vincent Pek

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2010

Added on May 12 2010

#general-database-discussions

16 comments

6,304 views