ORA-4030 out of process memory 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. |