My Oracle Support Banner

ORA-00600 [KGHALO2] AND KUP-04050 Error While Running SELECT Statement (Doc ID 1959633.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.


When trying to query an external table the following error is raised on screen:

SQL> select count(*) from SCHEMA.TABLENAME;
select count(*) from SCHEMA.TABLENAME
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04050: error while attempting to allocate 67108864 bytes of memory
ORA-06512: at "SYS.ORACLE_LOADER", line 52


The following error is reported in the alert.log at the same time:

Alert Log : ORA-00600: internal error code, arguments: [KGHALO2], [0x0], [], [], [], [], [], []


Memory Chunk information from the trace file written by the ORA-600 [KGHALO2] is similar to that below:

kghalo bad size 0x04000244
EXTENT 0 addr=0xfd687818
Chunk fd687820 sz=    67552    freeable  "Alloc environm "  ds=0xfd93bc60
Chunk fd8e3d64 sz=     1036    recreate  "kxs-heap-d     "  latch=(nil)
   ds fd858a74 sz=     1036 ct=        1
Chunk fd8e4170 sz=     1036    recreate  "kxs-heap-d     "  latch=(nil)
   ds fd88843c sz=     1036 ct=        1
Chunk fd8e457c sz=     1036    recreate  "kxs-heap-b     "  latch=(nil)




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.