H.2.1.3.2 LIMITED

When the PARALLEL_DEGREE_POLICY option in the FSI_PARALLEL_PARAMETERS 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, an automatic Degree of Parallelism is enabled for some statements, but statement queuing and in-memory Parallel Execution is 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.