My Oracle Support Banner

Degree Of Parallelism Is Not LIMITED By PARALLEL_DEGREE_LIMIT (Doc ID 1308910.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When parallel_Degree_policy is set to LIMITED, the parallel_degree_limit is
only affects when the queries that have objects decorated with degree
DEFAULT.

On the contrary, the older documentation was unclear since it did not mention DEFAULT
explicitly, in detail:


LIMITED

Enables automatic degree of parallelism for some statements but statement
queuing and in-memory Parallel Execution are disabled. Automatic degree of
parallelism is only applied to those statements that access tables or indexes
decorated explicitly with the PARALLEL clause. Tables and indexes that have a
degree of parallelism specified will use that degree of parallelism.

For example:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.