ORA-4030 Error Occurring in Parallel Execution

(Doc ID 1407383.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

ORA-4030 errors are occurring during parallel operations.  You see the following similar errors in the alert log:

Errors in file /u01/app/oracle/diag/rdbms/exadb/EXADB2/trace/EXADB2_ora_30061.trc (incident=90228):
ORA-00603: ORACLE server session terminated by fatal error
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 4: '+DATA_EX01/EXADB/datafile/undotbs2.389.762458481'
ORA-15081: failed to submit an I/O operation to a disk
ORA-04030: out of process memory when trying to allocate 7064 bytes (kxs-heap-w,kxfqlobf)
Incident details in: /u01/app/oracle/diag/rdbms/EXADB/EXADB2/incident/incdir_90228/EXADB2_ora_30061_i90228.trc
Errors in file /u01/app/oracle/diag/rdbms/EXADB/EXADB2/incident/incdir_90228/EXADB2_ora_30061_i90228.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-01115: IO error reading block from file (block # )
ORA-01110: data file 4: '+DATA_EX01/EXADB/datafile/undotbs2.389.762458481'
ORA-15081: failed to submit an I/O operation to a disk
ORA-04030: out of process memory when trying to allocate 7064 bytes (kxs-heap-w,kxfqlobf)
Fri Dec 16 17:02:36 2011
SMON: Parallel transaction recovery tried


In the incident file, you see the following information:

Dump file /u01/app/oracle/diag/rdbms/EXADB/EXADB2/incident/incdir_82792/EXADB2_ora_30061_i82792.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: exadb02.oracle.com
Release: 2.6.18-194.3.1.0.4.el5
Version: #1 SMP Sat Feb 19 03:38:37 EST 2011
Machine: x86_64
Instance name: EXADB2
Redo thread mounted by this instance: 2
Oracle process number: 95
Unix process pid: 30061, image: oracle@exadb02.oracle.com


*** 2011-12-16 17:02:04.570
*** SESSION ID:(1503.8613) 2011-12-16 17:02:04.570
*** CLIENT ID:() 2011-12-16 17:02:04.570
*** SERVICE NAME:(SV01) 2011-12-16 17:02:04.570
*** MODULE NAME:(SQL*Plus) 2011-12-16 17:02:04.570
*** ACTION NAME:() 2011-12-16 17:02:04.570

Dump continued from file: /u01/app/oracle/diag/rdbms/EXADB/EXADB2/trace/EXADB2_ora_30061.trc
ORA-04030: out of process memory when trying to allocate 7064 bytes (kxs-heap-w,kxfqlobf)

========= Dump for incident 82792 (ORA 4030) ========
----- Beginning of Customized Incident Dump(s) -----
=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------
70% 3078 MB, 456948 chunks: "kxfqlobf " SQL
kxs-heap-w ds=0x2acd99a82a88 dsprt=0x2acd997b67f8
30% 1300 MB, 358475 chunks: "permanent memory "
kxfpughea:ugi ds=0x2acd997c79a0 dsprt=0x2acd997b67f8
0% 14 MB, 456949 chunks: "kxfqlpbv " SQL
kxs-heap-w ds=0x2acd99a82a88 dsprt=0x2acd997b67f8
..

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