About
To enable parallelization of Data Manipulation Language (DML) statements such as INSERT, UPDATE, and DELETE , see this article How to enable parallelization ?
Articles Related
Rules
Rules for Parallelizing DML UPDATE and DELETE statements
The following rules apply when determining how to parallelize DML UPDATE and DELETE statements:
- Oracle can parallelize UPDATE and DELETE statements on partitioned tables, but only when multiple partitions are involved.
- You cannot parallelize UPDATE or DELETE operations on a nonpartitioned table or when such operations affect only a single partition.
Rules for Paralellizing DML INSERT statements
The following rules apply when determining how to parallelize DML INSERT statements:
- Standard INSERT statements using a VALUES clause cannot be parallelized.
- Oracle can parallelize only INSERT . . . SELECT . . . FROM statements.