Hi Joe, Jonathan Lewis wrote an article about pga settings that could answer your questions. http://www.jlcomp.demon.co.uk/snark.html Hope this helps, Giovanni 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? > > I have looked on metalink and in Chris Lawson's lastest book. I have yet > to > see a definative answer. > > thanks. > > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > -- > //www.freelists.org/webpage/oracle-l > -- -------------------------------------------------------------------- Another free oracle resource profiler http://sourceforge.net/projects/oraresprof/ New version 0.8 with many bug fixes and warnings on file truncated, timed_statistics=false, incorrect tracing deactivation and more