Wrong Result With Parallel Dml Enabled (Doc ID 2690671.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

good result execution plan:
============
Plan Table
============
| Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib |

| 0 | INSERT STATEMENT |
| 1 | LOAD AS SELECT | <TABLE NAME>
| 2 | PX COORDINATOR |
| 3 | PX SEND QC (ORDER) | :TQ10001
| 4 | SORT ORDER BY |
| 5 | PX RECEIVE |
| 6 | PX SEND RANGE | :TQ10000
| 7 | PX BLOCK ITERATOR |
| 8 | TABLE ACCESS STORAGE FULL | <TABLE NAME>
+++

Query Block Name / Object Alias(identified by operation id):

wrong result execution:
============
Plan Table

| Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib |
| 0 | INSERT STATEMENT |
| 1 | PX COORDINATOR |
| 2 | PX SEND QC (RANDOM) | :TQ10001
| 3 | LOAD AS SELECT (HIGH WATER MARK) | <TABLE NAME>
| 4 | SORT ORDER BY |
| 5 | PX RECEIVE |
| 6 | PX SEND PARTITION (KEY) | :TQ10000
| 7 | PX BLOCK ITERATOR |
| 8 | TABLE ACCESS STORAGE FULL | <TABLE NAME>

Cause

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