Oracle: does PARALLEL_DEGREE_LIMIT really limit the DOP?
Understanding Oracle Parallel Execution in 11.2 is a pain, not because the topic itself is overly complex, rather because Oracle made it much more complicated than it needed to be. Basically, the main initialization parameter that controls the parallel execution is PARALLEL_DEGREE_POLICY. According to Oracle online documentation, this parameter can be set to:
MANUAL: Disables automatic degree of parallelism, statement queuing, and in-memory parallel execution. This reverts the behaviour of parallel execution to what it was prior to Oracle Database 11g Release 2 (11.
[Read More]