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 AUGUST 25, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<SID>_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: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_77461/instname_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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<SID>_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: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_77462/instname_dw00_11403732_i77462.trc
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<SID>_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: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_77461/instname_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 <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<SID>_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: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_77462/instname_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
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 ...
----- 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
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
| Symptoms |
| Cause |
| Solution |
| References |