RE: pga_aggregate_target question
- From: "Hollis, Les" <Les.Hollis@xxxxxx>
- To: <giovanni.cuccu@xxxxxxxxx>, <joe_dba@xxxxxxxxxxx>
- Date: Thu, 6 Oct 2005 13:22:31 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Giovanni Cuccu
Sent: Thursday, October 06, 2005 10:53 AM
To: joe_dba@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@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:
