Re: pga_aggregate_target question

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_at_hotmail.com> 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/
>
> --
> http://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

--
http://www.freelists.org/webpage/oracle-l