14.1.1.2.2 LIMITED

When the PARALLEL_DEGREE_POLICY option in the FSI_OPTIMIZATION_SETTINGS table is set to LIMITED, the engine will begin each rule by issuing the following statement:ALTER SESSION SET PARALLEL_DEGREE_POLICY = 'LIMITED';

Under the LIMITED policy, automatic Degree of Parallelism is enabled 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 DEFAULT degree of parallelism using the PARALLEL clause. Statements executed against tables or indexes defined using an explicit Degree of Parallelism through the PARALLEL clause or statements including a parallel SQL hint may also run in parallel.