My Oracle Support Banner

Attempting to Execute a Parallel DML Statement From an ODP.NET Application Using the APPEND or PARALLEL Hint Results in Serial Execution (Doc ID 1370527.1)

Last updated on NOVEMBER 15, 2019

Applies to:

Oracle Data Provider for .NET - Version 10.2.0.1 and later
Microsoft Windows x64 (64-bit)
Generic Windows
Microsoft Windows (32-bit)
*** Checked for relevance on 26-Mar-2019 ***

Symptoms

Attempting to execute a parallel DML statement from an ODP.NET application using the APPEND or PARALLEL hint executes serially.

DML:

EXECUTE IMMEDIATE 'alter session enable parallel dml';
EXECUTE IMMEDIATE 'alter session enable parallel query';
INSERT /*+ APPEND PARALLEL */ into TABLE_DESTINATION SELECT /*+ PARALLEL*/ FROM TABLE_SOURCE


The same DML executes in Parallel when executed in SQL PLUS.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.