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 --