ORA-600 [qksxaCompactToXml:2] When Generating An Execution Plan (Doc ID 1626499.1)

Last updated on MARCH 20, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
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


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

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