pga settings useage oracle 10.2.0.4 enterprise on windows 2003

From: dba cjb <chris.brown_at_providentinsurance.co.uk>
Date: Tue, 6 Sep 2011 08:19:09 -0700 (PDT)
Message-ID: <374b6f80-51fc-4453-843b-9ee00cc9b4e4_at_z4g2000vbz.googlegroups.com>



I would like to manually control the amount of pga my session uses or is allowed to use

/ from 0 to 500m

Please could anyone on advise on parameters that I need to manipulate

cheers
Chris B

PS I want to do this so that I can force use of temp so that I can compare results on a fair basis between runs / a bit like alter system flush buffer_cache effect on sga; Received on Tue Sep 06 2011 - 10:19:09 CDT

Original text of this message