Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizing Database Productivity

Re: Optimizing Database Productivity

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 06 Sep 2005 23:09:18 GMT
Message-ID: <ykpTe.63439$EX.32694@twister.nyroc.rr.com>


Mark D Powell wrote:
> Actually even if pga_aggregate_target is in use I am pretty sure you
> should still set a value for sort_area_size as there are some
> situations where this value will be still be used. I saw this
> demonstrated in a post by Jonathan Lewis recently where he was pointing
> out the error in a posted article at a "self-proclaimed" expert site.
>
> I do not know where the article is posted but having a reasonable value
> set for sort_area_size when you change pga_aggregate_target to a
> non-zero value isn't going to hurt anything so I do not see a downside.
>
> HTH -- Mark D Powell --
>

http://www.jlcomp.demon.co.uk/untested.html

is probably what you are referring to.

Anurag Received on Tue Sep 06 2005 - 18:09:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US