14.1.1.2.1 MANUAL

When the PARALLEL_DEGREE_POLICY option in the FSI_OPTIMIZATION_SETTINGS 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 & Parallel DML is the same is it would have been prior to Oracle 11gR2. SQL statements will only be processed in parallel for objects declared with a PARALLEL clause or if a parallel SQL hint is included. Additionally, the Balance Computation Engine 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).