I.10 Enabling Parallel Execution of DML Statements

This section describes how to enable the Parallel Execution of DML Statements.

A configuration file, OracleDB.conf has been introduced to accommodate any configurable parameter related to operations on oracle database. If you do not want to set a parameter to a specific value, then the respective parameter entry can be removed/commented off form the OracleDB.conf file which resides in the path $FIC_DB_HOME/conf.

As of now, the OracleDB.conf file has only one parameter namely CNF_DEGREE_OF_ PARALLELISM. This parameter indicates the degree of parallelism to be used for a DML operation if parallel DML is explicitly enabled in the session with the ENABLE PARALLEL DML clause of the ALTER SESSION statement. The default mode of a session is DISABLE PARALLEL DML. If CNF_DEGREE_OF_PARALLELISM is not set, then the default degree, as decided by Oracle will be used.