Re: best way to invoke parallel in DW loads?
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: kjped1313@xxxxxxxxx
- Date: Mon, 14 Sep 2009 15:30:30 -0700
On Mon, Sep 14, 2009 at 10:14 AM, Kellyn Pedersen <kjped1313@xxxxxxxxx> wrote:
> As I'm also currently working in a new environment with tons of parallel
> processes without up to date statitistics- STATS are ESSENTIAL to efficient
> parallel process execution! I've been testing on a proof of concept that is
> showing up to 73% improvement in parallel processing performance just by
> having up to date statistics on partitions involved in any process. Mind you
> that these schemas are 2-6TB each, but the performance improvement percentage
> could be similar and worth the time to prove.
Ah ha! Someone else that realizes that the right execution plan has
more performance impact that any init.ora settings and the that
cornerstone of optimal execution plans is representative stats.
Please, go shout this from a mountain!!!
--
Regards,
Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l
Other related posts:
