Make sure that process limits (i.e. "ulimit -a") for the Oracle software owner account (usually "oracle") are set as recommended by Oracle Support, as in MetaLink note #169706.1?
ORA-04030 means that the Oracle process attempted to allocate more memory for heap, similar to using the C "malloc()" function, so process limits could be very relevant...
any quick ideas on how to fix this?
Fri Jun 2 17:07:11 2006
Doing block recovery for file 2 block 22497
Fri Jun 2 17:07:11 2006
Errors in file /u01/oracle/product/10.2.0.1/EE/admin/PROD2/bdump/prod2_smon_30391.trc:
ORA-04030: out of process memory when trying to allocate 8389132 bytes (pga heap,redo read buffer)
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
__________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
-- //www.freelists.org/webpage/oracle-l