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 11.2.0.1.0 and laterOracle 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 |