Re: Optimizing Database Productivity

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 6 Sep 2005 18:06:40 +0200
Message-ID: <431dbe8f$0$21630$ba620e4c@news.skynet.be>

"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message news:1126019821.413669.238810_at_g44g2000cwa.googlegroups.com...
> 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 --
>

I believe it is used when having shared server connections.

Matthias Received on Tue Sep 06 2005 - 11:06:40 CDT