Re: pga settings useage oracle enterprise on windows 2003

From: joel garry <>
Date: Tue, 6 Sep 2011 09:11:20 -0700 (PDT)
Message-ID: <>

On Sep 6, 8:19 am, dba cjb <> wrote:
> 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;

You should be able to achieve this with an alter session by setting sort_area_size and setting workarea_size_policy to manual, but it depends on your version/patch level, your pga_aggregate_target, what exactly you are doing, and probably some mysterious stuff. is interesting.


-- is bogus.
Received on Tue Sep 06 2011 - 11:11:20 CDT

Original text of this message