ORA-04030 (kxs-heap-c,temporary memory), ORA-04030 (kggec.c.kggfa,kggec.c.kggfa), ORA-04030 (TCHK^8380cfe1,qke.c.kggfa) While Using Datapump (Doc ID 2020389.1)

Last updated on NOVEMBER 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Running a Datapump export, this fails with error like below in the alert log:

Sat Jun 06 14:54:30 2015
Errors in file /npepdb04/oracle/diag/rdbms/fin1dev7/FIN1DEV7/trace/FIN1DEV7_dw00_11403732.trc  (incident=77461):
ORA-04030: out of process memory when trying to allocate 2336 bytes (kxs-heap-c,temporary memory)
Incident details in: /npepdb04/oracle/diag/rdbms/fin1dev7/FIN1DEV7/incident/incdir_77461/FIN1DEV7_dw00_11403732_i77461.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Jun 06 14:54:43 2015
Errors in file /npepdb04/oracle/diag/rdbms/fin1dev7/FIN1DEV7/trace/FIN1DEV7_dw00_11403732.trc  (incident=77462):
ORA-04030: out of process memory when trying to allocate 16432 bytes (kggec.c.kggfa,kggec.c.kggfa)
ORA-04030: out of process memory when trying to allocate 2336 bytes (kxs-heap-c,temporary memory)
Incident details in: /npepdb04/oracle/diag/rdbms/fin1dev7/FIN1DEV7/incident/incdir_77462/FIN1DEV7_dw00_11403732_i77462.trc

  
The trace file shows next PRIVATE MEMORY SUMMARY FOR THIS PROCESS in the trace file:

PRIVATE MEMORY SUMMARY FOR THIS PROCESS

PRIVATE HEAP SUMMARY DUMP
111 MB total:
  104 MB commented, 240 KB permanent
 7357 KB free (3839 KB in empty extents),
 65 MB,   3 heaps:   "callheap       "            38 KB free held
 22 MB,   1 heap:    "session heap   "            1575 KB free held
 18 MB,   1 heap:    "kxs-heap-c     "            743 KB free held
------------------------------------------------------
Summary of subheaps at depth 1
103 MB total:
93 MB commented, 8299 KB permanent
 2059 KB free (37 KB in empty extents),
 64 MB,   1 heap:    "TCHK^1b9b77a2  "          
 14 MB, 145 heaps:   "koh-kghu sessi "            339 KB free held
8668 KB, 4093 chunks:  "qkkele                    " 130 KB free held

 
The PL/SQL stack and function call stack from the trace file show call stacks like:

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
700010043b524f0      2688  package body SYS.DBMS_METADATA
700010043b524f0      3073  package body SYS.DBMS_METADATA
700010043b524f0      4269  package body SYS.DBMS_METADATA
700010043b524f0      4581  package body SYS.DBMS_METADATA
700010043b524f0      8160  package body SYS.DBMS_METADATA
700010043badab8     11566  package body SYS.KUPW$WORKER
700010043badab8      2808  package body SYS.KUPW$WORKER
700010043badab8     10422  package body SYS.KUPW$WORKER
700010043badab8      1824  package body SYS.KUPW$WORKER
700010043bb57f8         2  anonymous block

----- Call Stack Trace -----
... kghnospc kghalp ksmcat qkengcreate qkeeainit qkeAnalyzeAllExprs qkadrv2 opitca kksFullTypeCheck rpiswu2 kksSetBindType kksfbc opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_OPND pfrinstr_OPND pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe ...

 

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