Re: Odd Parallelism Behavior (11.2.0.4) when DEGREE=DEFAULT and INSTANCES=DEFAULT

On 2016/03/15 13:05, Chris Taylor wrote:

> "How to determine the Oracle default degree of parallelism - what controls/influences the "default" degree?"
>
> I thought it was default=1 but obviously that isn't true. Is there some way I can find the calculated DEFAULT degree of parallelism that Oracle might be using ?

I think
http://docs.oracle.com/cd/E11882_01/server.112/e41084/clauses006.htm#SQLRF20024 [1] holds the answer:

"If PARALLEL_DEGREE_POLICY is set to MANUAL, then the optimizer calculates a degree of parallelism equal to the number of CPUs available on all participating instances times the value of the PARALLEL_THREADS_PER_CPU initialization parameter."

The other scenarios are found on that page as well.

HTH! GL! Rich

Links:

--
http://www.freelists.org/webpage/oracle-l