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. 07-09-2004, 06:29 PM #1
    mike9
    mike9 is offline Advisor
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width