OraFAQ Forum: Server Administration » Any experience with the init parameter _pga_max

Home » RDBMS Server » Server Administration » Any experience with the init parameter _pga_max_size ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Any experience with the init parameter _pga_max_size ? [message #31654]

Fri, 09 July 2004 15:30

Mike
Messages: 417
Registered: September 1998

Senior Member

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

Report message to a moderator

Re: Any experience with the init parameter _pga_max_size ? [message #31668 is a reply to message #31654]

Sat, 10 July 2004 22:45

Frank
Messages: 7901
Registered: March 2000

Senior Member

Maybe this will help:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:8759826405304

hth

Report message to a moderator

Previous Topic:	_pga_max_size ?
Next Topic:	Options parameter in SYS.DBMS_LOGMNR.START_LOGMNR

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 04:41:20 CST 2025