Re: pga_aggregate_target question

  • From: Giovanni Cuccu <giovanni.cuccu@xxxxxxxxx>
  • To: joe_dba@xxxxxxxxxxx
  • Date: Thu, 6 Oct 2005 17:53:21 +0200

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

Other related posts: