ORA-600 [KCBLSLTIO_1] in Parallel Query (Doc ID 1980662.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms


The following error is reported:

ORA-00600: internal error code, arguments: [kcblsltio_1], [0], [0], [], [], [], [], [], [], [], [], []

 The call stack in the incident trace file written by the error contains the following functions:

kxfpProcessError <- kxfpProcessMsg <- kxfpqidqr <- kxfpqdqr <- kxfxgs <- kxfxcw <- qerpxFetch

 The Current SQL in the incident trace shows a Parallel Hint is being used:

SELECT /*+ FULL(pat) PARALLEL(pat,4) */
MOD(pat.pat_id,4)+1||'^'||
TO_CHAR(sysdate,'MM/DD/YYYY HH24:MI:SS')||'^'||
pat.pat_algy_hlth_type_cd||'^'||
pat.pat_algy_hlth_cd_inq_ind||'^'||
pat.pat_city||'^'||
TO_CHAR(pat.pat_id)||'^'||
pat.pat_state||'^'||
pat.pat_street_addr||'^'||
pat.pat_zip||'^'||
TO_CHAR(pat.update_dttm,'MM/DD/YYYY HH24:MI:SS')||'^'||
pat.update_user_id||'^'||

 The Explain Plan also shows use of parallel processing:

---------------------------------------------------------------------------+-----------------------------------+-------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time | TQ |IN-OUT|PQ Distrib |
---------------------------------------------------------------------------+-----------------------------------+-------------------------+
| 0 | SELECT STATEMENT | | | | 34K | | | | |
| 1 | HASH GROUP BY | | 243K | 27M | 34K | 00:07:04 | | | |
| 2 | FILTER | | | | | | | | |
| 3 | PX COORDINATOR | | | | | | | | |
| 4 | PX SEND QC (RANDOM) | :TQ10004 | 2029K | 228M | 21K | 00:04:23 |:Q1004| P->S |QC (RANDOM)|
| 5 | HASH JOIN RIGHT OUTER BUFFERED | | 2029K | 228M | 21K | 00:04:23 |:Q1004| PCWP | |
| 6 | BUFFER SORT | | | | | |:Q1004| PCWC | |
| 7 | PX RECEIVE | | 1753K | 22M | 4263 | 00:00:52 |:Q1004| PCWP | |
| 8 | PX SEND HASH | :TQ10001 | 1753K | 22M | 4263 | 00:00:52 | | S->P |HASH |
| 9 | TABLE ACCESS BY INDEX ROWID | TBF0_PAT_ALGY_HLTH_CD | 1753K | 22M | 4263 | 00:00:52 | | | |
| 10 | INDEX SKIP SCAN | UXF0_PAT_ALGY_HLTH_CD_01| 751K | | 161 | 00:00:02 | | | |
| 11 | HASH JOIN RIGHT OUTER | | 2029K | 202M | 17K | 00:04:31 |:Q1004| PCWP | |
| 12 | BUFFER SORT | | | | | |:Q1004| PCWC | |
| 13 | PX RECEIVE | | 697K | 9059K | 4263 | 00:00:52 |:Q1004| PCWP | |
| 14 | PX SEND HASH | :TQ10002 | 697K | 9059K | 4263 | 00:00:52 | | S->P |HASH |
| 15 | TABLE ACCESS BY INDEX ROWID | TBF0_PAT_ALGY_HLTH_CD | 697K | 9059K | 4263 | 00:00:52 | | | |

 

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