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!

Should i increase PGA when PROCESS parameter is increased?

John_75Nov 24 2008 — edited Nov 24 2008

DB version:10gR2

Currently our PROCESSes parameter is set to 500 and PGA_AGGREGATE_TARGET set to 700mb. We are going to increase init.ora parameter PROCESSES to 1000. Should i be increasing PGA_GGREGATE_TARGET as well?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 22 2008

Added on Nov 24 2008

#general-database-discussions

4 comments

863 views