Re: smon 4030 - quick ideas?

checked ulimits first, no probs there, smon has accumulated over a gb of 
memory, been getting that message over and over for over and hour. Only thing I 
can think of is stop/starting the instance to free up the smon memory.

Tim Gorman <tim@xxxxxxxxx> wrote: 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
>



 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Other related posts: