ORA-600 [KCBLSLTIO_1] in Parallel Query
(Doc ID 1980662.1)
Last updated on JULY 31, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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(<table_name>) PARALLEL(table_name>,4) */
*
FROM
<TABLE_NAME>;
*
FROM
<TABLE_NAME>;
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 | <TABLE_NAME1> | 1753K | 22M | 4263 | 00:00:52 | | | |
| 10 | INDEX SKIP SCAN | <INDEX_NAME1>| 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 | <TABLE_NAME2> | 697K | 9059K | 4263 | 00:00:52 | | | |
| 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 | <TABLE_NAME1> | 1753K | 22M | 4263 | 00:00:52 | | | |
| 10 | INDEX SKIP SCAN | <INDEX_NAME1>| 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 | <TABLE_NAME2> | 697K | 9059K | 4263 | 00:00:52 | | | |
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 |
| References |