Oracle Database - Parallel DML

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.