View Single Post

   
  #1 (permalink)  
Old 02-25-2008, 03:57 AM
dbaplusplus@hotmail.com
 
Posts: n/a
Default 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.

Reply With Quote