Re: smon 4030 - quick ideas?
- From: fairlie rego <fairlie_r@xxxxxxxxx>
- To: orclwzrd@xxxxxxxxx
- Date: Fri, 2 Jun 2006 17:19:19 -0700 (PDT)
Hi,
If you are on 10G you could be hitting bug 4970079 but without a pga heap
dump or an errorstack I cannot confirm.
The following C program might tell you how much maximum memory a process can
allocate on your box and then encounter a 4030.
Note : Since I don't have access to a system right now I haven't tested it
/* 4030 prog */
int main (int argc, char**argv) {
char * buff;
int mbCount = 0;
while (1) {
buff = (char *) malloc(1024*1024);
if (buff == (char *)0) {
printf("Out of memory\n");
exit(0);
}
mbCount += 1;
printf("Allocated %d MB\n", mbCount);
}
}
Thanks
Fairlie
John D Parker <orclwzrd@xxxxxxxxx> wrote:
alter system checkpoint hung, had to ctrl-c. issued shutdown abort, startup
restrict, shutdown immediate, startup. all appears well at this point.
hopefully will stay that way
John D Parker <orclwzrd@xxxxxxxxx> wrote: 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
__________________________________________________
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
Fairlie Rego
Senior Oracle Consultant
Optus Telecommunications
www.optus.com.au
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Other related posts:
