Re: best way to invoke parallel in DW loads?
Date: Wed, 16 Sep 2009 15:46:51 +0200
just a small correction:
(at least in 18.104.22.168, have not tested 10gR2) these parameters are calculated from CPU_COUNT:
> CPU_COUNT -> please don't change this. Let Oracle figure it out. In 10g it's an underscore parameter and it doesn't make much sense to mess with it. The only impact that a manual change will have (I believe) is the default parallel degree, calculated by CPU_COUNT * PARALLEL_THREADS_PER_CPU.
Neil, if you want to tweek there, be careful and make good records about all related changes for tracability.