14.1.1.1.8 FORCE

When the PARALLEL_DML option in the FSI_OPTIMIZATION_SETTINGS table is set to FORCE and the PARALLEL_DOP parameter is set to NULL, the engine will begin each rule by issuing the following statement:

ALTER SESSION FORCE PARALLEL DML;

After this ALTER SESSION statement, subsequent DML statements are executed with the default Degree of Parallelism for the database unless (a) the objects against which the SELECT statement operates have been defined as having a specific Degree of Parallelism through the use of the PARALLEL clause or (b) the SELECT statement includes a parallel hint. A parallel hint will override the Degree of Parallelism specified through a PARALLEL clause. Again, for details on how the Oracle database determines the default Degree of Parallelism, see Oracle Database VLDB and Partitioning Guide.