Default: NONE
Purpose
The DEGREE_OF_PARALLELISM parameter specifies the degree of parallelism to use during the load operation.
Syntax and Description
DEGREE_OF_PARALLELISM=[degree-num|DEFAULT|AUTO|NONE]
If a degree-num is specified, then it must be a whole number value from 1 to n.
If DEFAULT is specified, then the default parallelism of the database (not the default parameter value of AUTO) is used.
If AUTO is used, then the Oracle database automatically sets the degree of parallelism for the load.
If NONE is specified, then the load is not performed in parallel.
See Also:
Oracle Database VLDB and Partitioning Guide for more information about parallel execution
Restrictions
The DEGREE_OF_PARALLELISM parameter is valid only when the external table load method is used.
Example
The following example sets the degree of parallelism for the load to 3.
DEGREE_OF_PARALLELISM=3