Oracle Database - Parallel DML

> Database > Oracle Database

1 - About

To enable parallelization of Data Manipulation Language (DML) statements such as INSERT, UPDATE, and DELETE , see this article How to enable parallelization ?

Advertising

3 - Rules

3.1 - 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.

3.2 - 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.