My Oracle Support Banner

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

Last updated on NOVEMBER 07, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 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.


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

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


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:




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

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