H.2.1.3.1 MANUAL

When the PARALLEL_DEGREE_POLICY option in the FSI_PARALLEL_PARAMETERS table is set to MANUAL, the engine will begin each rule by issuing the following statement:

ALTER SESSION SET PARALLEL_DEGREE_POLICY = 'MANUAL';

The subsequent behavior of both Parallel Query and Parallel DML is the same as it would have been before Oracle 11gR2. SQL statements is only processed in parallel for objects declared with a PARALLEL clause or if a parallel SQL hint is included. Additionally, the Profitability Management PARALLEL_QUERY parameter must be set to either ENABLE or FORCE (for Parallel Query) and the PARALLEL_DML parameter must be set to either ENABLE or FORE (for Parallel DML).