yes it does, see the loooong thread that was on askTom recently 'super sizing your pga' and also a number of articles on www.jlcomp.demon.co.uk<http://www.jlcomp.demon.co.uk> On 10/6/05, Joe Smith <joe_dba@xxxxxxxxxxx> wrote: > > If you set the parameter pga_aggregate_target and sort_area_size does > oracle > still use the sort area size parameter? >