Skip to Main Content

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_AGGREGATE_TARGET is 0, should I give it a value?

2753191Oct 28 2016 — edited Nov 3 2016

Hi,

The PGA_AGGREGATE_TARGET parameter of my Oracle instance is 0.

Should I set it to automatic by giving it a value?

Will ‘automatic’ give us better and more stable overall database performance?

Any ideas?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 1 2016
Added on Oct 28 2016
15 comments
2,371 views