Degree Of Parallelism Is Not LIMITED By PARALLEL_DEGREE_LIMIT
(Doc ID 1308910.1)
Last updated on SEPTEMBER 20, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.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.
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.
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