ny experience with the init parameter _pga_max_size ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: ny experience with the init parameter _pga_max_size ?

Threaded View

  1. #1
    Join Date
    Mar 2002
    Posts
    534

    Any experience with the init parameter _pga_max_size ?

    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 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

    http://www.dbasupport.com/forums/sho...threadid=41361
    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