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 JULY 05, 2017
Applies to:
Oracle Data Provider for .NET - Version 10.2.0.1 and laterMicrosoft Windows (32-bit)
Microsoft Windows x64 (64-bit)
Generic Windows
***Checked for relevance on 03-Jul-2017***
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
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.
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 |
| Cause |
| Solution |