Ora-600 [15570] during the execution of a parallel query if join predicate has been pushed (Doc ID 1083366.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.2.0.1 - Release: 10.2 to 11.2
Information in this document applies to any platform.

Symptoms

When create a table in parallel using for example

create table ZZTP
PARALLEL 8 as
select /*+ PARALLEL 8 */ a11.ART_RESSORT_ID ART_RESSORT_ID,
a11.ART_BEREICH_ID ART_BEREICH_ID,
...

ERROR
------
ORA-00600: Interner Fehlercode, Argumente: [15570], [], [], [], [], [], [], []
occurs.

============
Plan Table
============
----------------------------------------------------------------------------------+-----------------------------------+-------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib |
----------------------------------------------------------------------------------+-----------------------------------+-------------------------+
| 0 | CREATE TABLE STATEMENT | | | | 33 | | | | |
| 1 | PX COORDINATOR | | | | | | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10005 | 7 | 315 | 32 | 00:00:01 |:Q1005| P->S |QC (RANDOM)|
| 3 | LOAD AS SELECT | | | | | |:Q1005| PCWP | |
| 4 | HASH GROUP BY | | 7 | 315 | 32 | 00:00:01 |:Q1005| PCWP | |
| 5 | PX RECEIVE | | 7 | 315 | 31 | 00:00:01 |:Q1005| PCWP | |
| 6 | PX SEND HASH | :TQ10004 | 7 | 315 | 31 | 00:00:01 |:Q1004| P->P |HASH |
| 7 | BUFFER SORT | | 7 | 315 | 32 | 00:00:01 |:Q1004| PCWP | |
| 8 | NESTED LOOPS | | 7 | 315 | 31 | 00:00:01 |:Q1004| PCWP | |
| 9 | BUFFER SORT | | | | | |:Q1004| PCWC | |
| 10 | PX RECEIVE | | | | | |:Q1004| PCWP | |
| 11 | PX SEND BROADCAST | :TQ10000 | | | | | | S->P |BROADCAST |
| 12 | NESTED LOOPS | | 18 | 432 | 2 | 00:00:01 | | | |
| 13 | INDEX RANGE SCAN | IDX704120920260000 | 1 | 12 | 1 | 00:00:01 | | | |
| 14 | TABLE ACCESS BY INDEX ROWID | DAT_TAGKUM_M_TAGS2 | 18 | 216 | 1 | 00:00:01 | | | |
| 15 | INDEX RANGE SCAN | FK_DATTAGS_DATUM2 | 18 | | 1 | 00:00:01 | | | |
| 16 | VIEW | F_MEMI_FAGTINFO | 1 | 21 | | |:Q1004| PCWP | |
| 17 | UNION ALL PUSHED PREDICATE | | | | | |:Q1004| PCWP | |
| 18 | NESTED LOOPS | | 1 | 90 | 13 | 00:00:01 |:Q1004| PCWP | |
| 19 | HASH JOIN | | 1 | 82 | 12 | 00:00:01 |:Q1004| PCWP | |
| 20 | BUFFER SORT | | | | | |:Q1004| PCWC | |
| 21 | PX RECEIVE | | | | | |:Q1004| PCWP | |
| 22 | PX SEND HASH | :TQ10001 | | | | | | S->P |HASH |
| 23 | NESTED LOOPS | | | | | | | | |
| 24 | NESTED LOOPS | | 11 | 704 | 10 | 00:00:01 | | | |
| 25 | TABLE ACCESS BY INDEX ROWID | MEMI_FAGT | 11 | 341 | 4 | 00:00:01 | | | |
| 26 | BITMAP CONVERSION TO ROWIDS | | | | | | | | |
| 27 | BITMAP AND | | | | | | | | |
| 28 | BITMAP CONVERSION FROM ROWIDS | | | | | | | | |
| 29 | INDEX RANGE SCAN | FK_ART_ARTIKEL_137 | 123 | | 1 | 00:00:01 | | | |
| 30 | BITMAP INDEX SINGLE VALUE | FK_ART_ARTIKEL_135 | | | | | | | |
| 31 | INDEX UNIQUE SCAN | PK_FACT_ARTIKEL_SORTE| 1 | | 1 | 00:00:01 | | | |
| 32 | TABLE ACCESS BY INDEX ROWID | ARTIKEL_SORTE | 1 | 33 | 1 | 00:00:01 | | | |
| 33 | BUFFER SORT | | | | | |:Q1004| PCWC | |
| 34 | PX RECEIVE | | 6 | 108 | 2 | 00:00:01 |:Q1004| PCWP | |
| 35 | PX SEND HASH | :TQ10003 | 6 | 108 | 2 | 00:00:01 |:Q1003| P->P |HASH |
| 36 | PX BLOCK ITERATOR | | 6 | 108 | 2 | 00:00:01 |:Q1003| PCWC | |
| 37 | TABLE ACCESS FULL | XCHANGE_SAISON | 6 | 108 | 2 | 00:00:01 |:Q1003| PCWP | |
| 38 | INDEX RANGE SCAN | BZK4LIEF2FIL_1 | 2 | 16 | 1 | 00:00:01 |:Q1004| PCWP | |
| 39 | BUFFER SORT | | | | | |:Q1004| PCWC | |
| 40 | PX RECEIVE | | 1 | 90 | 7 | 00:00:01 |:Q1004| PCWP | |
| 41 | PX SEND ROUND-ROBIN | :TQ10002 | 1 | 90 | 7 | 00:00:01 | | S->P |ROUND-ROBIN|
| 42 | NESTED LOOPS | | 1 | 90 | 7 | 00:00:01 | | | |
| 43 | NESTED LOOPS | | 1 | 82 | 6 | 00:00:01 | | | |
| 44 | NESTED LOOPS | | 5 | 320 | 5 | 00:00:01 | | | |
| 45 | TABLE ACCESS BY INDEX ROWID | LFBL_FAGT | 5 | 155 | 2 | 00:00:01 | | | |
| 46 | INDEX RANGE SCAN | FK_ART_ARTIKEL_I43 | 34 | | 1 | 00:00:01 | | | |
| 47 | TABLE ACCESS BY INDEX ROWID | ARTIKEL_SORTE | 1 | 33 | 1 | 00:00:01 | | | |
| 48 | INDEX UNIQUE SCAN | PK_FACT_ARTIKEL_SORTE| 1 | | 1 | 00:00:01 | | | |
| 49 | TABLE ACCESS BY INDEX ROWID | XCHANGE_SAISON | 1 | 18 | 1 | 00:00:01 | | | |
| 50 | INDEX RANGE SCAN | XCHANGE_SAISON1 | 19 | | 1 | 00:00:01 | | | |
| 51 | INDEX RANGE SCAN | BZK4LIEF2FIL_1 | 2 | 16 | 1 | 00:00:01 | | | |
----------------------------------------------------------------------------------+-----------------------------------+-------------------------+

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms