Re: smon 4030 - quick ideas?

  • From: Tim Gorman <tim@xxxxxxxxx>
  • To: orclwzrd@xxxxxxxxx
  • Date: Fri, 02 Jun 2006 16:27:51 -0600

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...



John D Parker wrote:
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


Other related posts: