RE: best way to invoke parallel in DW loads?

From: Amihay Gonen <>
Date: Wed, 16 Sep 2009 16:54:00 +0300
Message-ID: <>

In 11Gr2 this parameter can be used to CPU caging.

-----Original Message-----
From: [] On Behalf Of Martin Berger Sent: Wednesday, September 16, 2009 4:47 PM To:
Cc:; Subject: Re: best way to invoke parallel in DW loads?


just a small correction:
(at least in, 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.



Received on Wed Sep 16 2009 - 08:54:00 CDT

Original text of this message