ORA-4030 out of process memory

From: <dbaplusplus_at_hotmail.com>
Date: 9 Mar 2006 12:16:46 -0800
Message-ID: <1141935406.198860.195250@j33g2000cwa.googlegroups.com>

I am using Oracle 9.2.0.5 on HP UNIX 11i. It is a production system. Following error occurs:

ORA-21503: program terminated by fatal error ORA-04030: out of process memory when trying to allocate 32768 bytes (Alloc statemen,prefetch buff a
lloc)

This error is not shown in alert.log file instead reported by a third party application.
I set event in init.ora:

SQL> show parameter event;

NAME TYPE VALUE

------------------------------------ -----------
------------------------------

event string 21503 trace name errorstack le vel 3, 04030 trace name errors
tack level 3

Hoping that some information will be written in Oracle trace files but none is written.

I have 20GB of free memory on that server (so OS memory exhaustion on database server should no be an issue). IPGA_AGGREGATE_TARGET was set to 2GB.

I have read many articles on metalink as well as on internet, however, cannot find the actual cause.

Any ideas on how to troubleshoot this information will be helpful. Received on Thu Mar 09 2006 - 14:16:46 CST