1.54 CONTAINERS_PARALLEL_DEGREE
CONTAINERS_PARALLEL_DEGREE
can be used to control the degree of parallelism of a query involving containers().
Property | Description |
---|---|
Parameter type |
Integer |
Default value |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
Cannot be set to a value lower than |
Basic |
No |
Oracle RAC |
Different values can be set on different instances. |
The value of CONTAINERS_PARALLEL_DEGREE
, if set, will override the default DOP for a containers() query.
By default, a containers() query uses a degree of parallelism equal to (1
+ number of open PDBs) in the case of CDB root and (1
+ number of open application PDBs) in the case of application root.
If the value of CONTAINERS_PARALLEL_DEGREE
is lower than 65535
, then this value is used as the degree of parallelism of a query involving containers(). Otherwise (when the value is 65535
), the default degree of parallelism is (1
+ number of open PDBs) or (1
+ number of open application PDBs) as described above.
See Also:
-
Oracle Multitenant Administrator's Guide for more information about CDB roots
-
Oracle Multitenant Administrator's Guide for more information about application roots