ORA-600 [723] Memory Leak for DataPump Import (Impdp) (Doc ID 2031408.1)

Last updated on MAY 19, 2017

Applies to:

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

Symptoms

Below error is reported in the alert log during datapump import:

Errors in file /opt/oracle/diag/rdbms/sdkdb/sdkdb1/trace/sdkdb1_dw01_13645.trc  (incident=204180):
ORA-00600: internal error code, arguments: [723], [106560], [5329656], [memory leak], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/sdkdb/sdkdb1/incident/incdir_204180/sdkdb1_dw01_13645_i204180.trc
Sat Jun 13 12:42:22 2015
Errors in file /opt/oracle/diag/rdbms/sdkdb/sdkdb1/trace/sdkdb1_dw02_13653.trc  (incident=204188):
ORA-00600: internal error code, arguments: [723], [106560], [5329656], [memory leak], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/sdkdb/sdkdb1/incident/incdir_204188/sdkdb1_dw02_13653_i204188.trc


The trace file shows memory leak under "trans_kgcbz2sta":

========= Dump for incident 204100 (ORA 600 [723]) ========
----- Beginning of Customized Incident Dump(s) -----
******** ERROR: PGA memory leak detected 5329656 > 106560 ********
******************************************************
HEAP DUMP heap name="pga heap"  desc=0x9fcd620
extent sz=0x20c0 alt=184 het=32767 rec=0 flg=3 opc=3
parent=(nil) owner=(nil) nex=(nil) xsz=0x4fff0 heap=(nil)
fl2=0x60, nex=(nil)
EXTENT 0 addr=0x7f213b6d1010
 Chunk     7f213b6d1020 sz=    65480    free      "               "
 Chunk     7f213b6e0fe8 sz=  1048600    freeable  "trans_kgcbz2sta"
Dump of memory from 0x00007F213B6E0FE8 to 0x00007F213B7E1000
7F213B6E0FE0                   00100019 10B38F00          [........]
7F213B6E0FF0 3B6D1020 00007F21 08A9EEC8 00000000  [ .m;!...........]
7F213B6E1000 00000000 00000000 00000000 00000000  [................]
 Repeat 65535 times
EXTENT 1 addr=0x7f213aed1010
 Chunk     7f213aed1020 sz=    65480    free      "               "
 Chunk     7f213aee0fe8 sz=  4194328    freeable  "buf_kgcbz2state"
Dump of memory from 0x00007F213AEE0FE8 to 0x00007F213B2E1000
7F213AEE0FE0                   00400019 10B38F00          [..@.....]
7F213AEE0FF0 3AED1020 00007F21 08A9EEB8 00000000  [ ..:!...........]
7F213AEE1000 200A3E3E 6C2C2C0A 5628303D 503B412C  [>>. .,,l=0(V,A;P]

 

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