APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 12-Nov-2013***
SYMPTOMS
ORA-04030 is reported while executing RMAN. The alert log confirms, this occurs while requesting memory for the heaps labelled: (KSFQ heap,KSFQ Buffers)
ORA-04030: out of process memory when trying to allocate 1052684 bytes (KSFQ heap,KSFQ Buffers)
The trace file also confirms largest allocated heap is "KSFQ Buffers "
ORA-04030: out of process memory when trying to allocate 1052684 bytes (KSFQ heap,KSFQ Buffers)
========= Dump for incident 68401 (ORA 4030) ========
----- Beginning of Customized Incident Dump(s) -----
=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------
94% 731 MB, 731 chunks: "KSFQ Buffers "
KSFQ heap ds=0xf62ea770 dsprt=0x1132b860
5% 42 MB, 738 chunks: "free memory "
pga heap ds=0x1132b860 dsprt=(nil)
0% 896 KB, 183 chunks: "KSFQ ctx "
KSFQ heap ds=0xf62ea770 dsprt=0x1132b860
...
----- Call Stack Trace -----
kghalf ksfqbalo ksfqbcre ksfqxc ksfqxcrx ksfqxcre ...
Inside the trace file search for string "al7sqlp"
al7sqlp: at 0xfeffbf60
[22535953 534D4244 4341425F 5F50554B] [SYS"DBMS_BACKUP_]
[54534552 2245524F 494C4156 49544144] [RESTORE"VALIDATI]
[41564E4F 4144494C 22224554 ] [ONVALIDATE""]
If this shows SYS.DBMS_BACKUP_RESTORE.VALIDATIONVALIDATE then it's a confirmation for
Bug 10635701.
CHANGES
RMAN backup was executed.
CAUSE
This issue was caused by Bug 10635701 when the following is true:
ORA-04030 was reported while RMAN executedThe heap name is "KSFQ Buffers"SYS.DBMS_BACKUP_RESTORE.VALIDATIONVALIDATE was confirmed either by RMAN tracing or by trace file (see: string "al7sqlp")
SOLUTION
FIXED RELEASES
12.1.0.1 (Base Release)11.2.0.3 (Server Patch Set)11.2.0.2.5 Database Patch Set Update11.2.0.2.5 Grid Infrastructure Patch Set Update (GI PSU)11.2.0.2 Bundle Patch 5 for Exadata Database11.2.0.2 Patch 11 on Windows Platforms
WORKAROUND
None.
PATCH FIX
Please use the following link to check if there is a
Patch 10635701 for your platform.
Patches for Windows Platforms: See
Note 161549.1 - Oracle Database Server and Networking Patches for Microsoft Platforms
