Re: Optimizing Database Productivity

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 6 Sep 2005 08:17:01 -0700
Message-ID: <1126019821.413669.238810@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 -- Received on Tue Sep 06 2005 - 10:17:01 CDT