RE: pga_aggregate_target question

From: Hollis, Les <Les.Hollis_at_ps.net>
Date: Thu, 6 Oct 2005 13:22:31 -0500
Message-ID: <683E0A1C82D75246BD9F4E01F77CBB0F01A0E0B3@pscdalpexch02.perotsystems.net>

You could also look at Don Burleson's article for a "LITTLE" differing view from Johnathon Lewis

http://searchoracle.techtarget.com/tip/1,289483,sid41_gci1116697,00.html ?track=NL-93&ad=525740

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Giovanni Cuccu Sent: Thursday, October 06, 2005 10:53 AM To: joe_dba_at_hotmail.com
Cc: oracle-l_at_freelists.org
Subject: 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 Received on Thu Oct 06 2005 - 13:26:16 CDT