DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Threaded View

  1. #1
    Join Date
    Mar 2002

    Any experience with the init parameter _pga_max_size ?


    I'm working on DWH Project using Oracle 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 allocates 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 I 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

    Last edited by mike9; 07-09-2004 at 07:44 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.