pga settings useage oracle enterprise on windows 2003

From: dba cjb <>
Date: Tue, 6 Sep 2011 08:19:09 -0700 (PDT)
Message-ID: <>

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

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