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!

any experience with the init parameter _pga_max_size ?

137669Jul 9 2004 — edited Aug 25 2005

Hi,

I'm working on DWH Project using Oracle 9.2.0.5 Our production servers has 20cpus and around 40Gb of ram. The pga_aggregate_target is set to 16GB and workarea_size_policy is set to AUTO.

The big problem we have is that from these 16GB of PGA only 5GB are used (based on V$PGASTAT). The reason for that is that Oracle never alocates more then 100MB of PGA to a serial or a parallel process.

So to improve the performance of these queries which need more then 100MB of PGA was thinking about to use the parameter "_pga_max_size" and to set it to 256MB.

Has anybody so experience with this parameter?

Thanks for any feedback

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2005

Added on Jul 9 2004

#general-database-discussions

28 comments

6,671 views