ORA-600 [qksxaCompactToXml:2] When Generating An Execution Plan
(Doc ID 1626499.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When generating an execution plan (for example with dbms_xplan.display_cursor) getting:
ORA-00600: internal error code, arguments: [qksxaCompactToXml:2], [56], [], [], [], [], [], [], [], [], [], []
The trace file references V$SQL_PLAN in the current sql and package SYS.DBMS_XPLAN in the PL/SQL Stack, e.g.:
----- Current SQL Statement for this session (sql_id=6v16cdw29w4rx) -----
SELECT /*+ opt_param('parallel_execution_enabled', 'false') */
/* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space,
cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates,
filter_predicates, other, qblock_name, object_alias, other_xml, sql_profile, sql_plan_baseline, ...
...
from V$SQL_PLAN vp, v$sql
where ...
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x51781bb60 2886 package body SYS.DBMS_XPLAN
0x51781bb60 5075 package body SYS.DBMS_XPLAN
0x50f438e80 1 anonymous block
SELECT /*+ opt_param('parallel_execution_enabled', 'false') */
/* EXEC_FROM_DBMS_XPLAN */ id, position, depth , operation, options, object_name, cardinality, bytes, temp_space,
cost, io_cost, cpu_cost, time, partition_start, partition_stop, object_node, other_tag, distribution, null, access_predicates,
filter_predicates, other, qblock_name, object_alias, other_xml, sql_profile, sql_plan_baseline, ...
...
from V$SQL_PLAN vp, v$sql
where ...
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x51781bb60 2886 package body SYS.DBMS_XPLAN
0x51781bb60 5075 package body SYS.DBMS_XPLAN
0x50f438e80 1 anonymous block
The call stack from the trace file includes functions like:
... qksxaCompactToXml xplCompactToOtherXml xplNodeToRow xplMakeRow xplFetchRow kqlfgx kgligi kglic_cbk kglic0 kglic ...
The trace file contains a Plan Table that may reference X$KQLFXPL:
=========== Plan Table ============ ---------------------------------------------------------------+-----------------------------------+ | Id | Operation | Name | Rows | Bytes | Cost | Time | ---------------------------------------------------------------+-----------------------------------+ | 0 | SELECT STATEMENT | | | | 1 | | | 1 | SORT ORDER BY | | 1 | 8837 | 1 | 00:00:01 | | 2 | VIEW | | 1 | 8837 | 0 | | | 3 | NESTED LOOPS | | 1 | 8620 | 0 | | | 4 | FIXED TABLE FIXED INDEX | X$KGLCURSOR_CHILD (ind:2)| 1 | 104 | 0 | | | 5 | FIXED TABLE FIXED INDEX | X$KQLFXPL (ind:4) | 1 | 8516 | 0 | | ---------------------------------------------------------------+-----------------------------------+
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 |