ORA-600 [kglslod:subheap], [9], [0x...], [] Loading Data

(Doc ID 1325116.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

- You are encountering ORA-600 [kglslod:subheap], [9], [0x...], [] on a 10.2.0.5, 11.1.0.6 or 11.1.0.7 database, most often running on an AIX platform but not exclusive to this platform.

- ORA-600 is raised on insert statements of the form:
    INSERT /*+ SYS_DL_CURSOR */ INTO "<user_name>"."<table_name>" ("<column_name_1>","<column_name_2>","<column_name_3>","<column_name_4>","<column_name_5>"...<column_name_n>)
      VALUES (NULL,NULL,NULL,NULL,NULL...NULL)

- often during data load using Informatica 3rd-party tool

- with the following functions on the call stack:
  ... kglslod kqlslod kqlsublod kqllod kglobld ...

- Plan Table showing:
   --------------------------------------------+-----------------------------------+
   | Id | Operation | Name | Rows | Bytes | Cost | Time |
   --------------------------------------------+-----------------------------------+
   | 0 | INSERT STATEMENT | | | | 1 | |
   | 1 | LOAD TABLE CONVENTIONAL | | | | | |
   --------------------------------------------+-----------------------------------+

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