Oracle Database - Parallel DML

Card Puncher Data Processing

About

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

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.





Discover More
Owb Mapping Configuration
OWB - Mapping Configuration

What means the different values configuration of a mapping. Properties Description Deployable If you disable it, scripts for that mapping are not generated. Language Warehouse Builder sets...
Card Puncher Data Processing
Oracle Database - How to (enable|disable) parallel query and get (degree of parallelism|DOP) ?

How to enable a parallel execution: for a for a operation Small tables/indexes (up to thousands of records; up to 10s of data blocks) should never be enabled for parallel execution. Operations...



Share this page:
Follow us:
Task Runner