smon 4030 - quick ideas? 2006-06-02 - By fairlie rego
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@(protected)> 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@(protected)> 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@(protected)> 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 (See ORA-04030.ora-code.com) 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 (See ORA-04030.ora-code.com): 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
<div>Hi,</div> <div> </div> <div>If you are on 10G you could be hitting
bug 4970079 but without a pga heap dump or an errorstack I cannot confirm.</div
> <div> </div> <div>The following C program might tell you how much
maximum memory a process can allocate on your box and then encounter a 4030.<
/div> <div> </div> <div>Note : Since I don't have access to a system
right now I haven't tested it</div> <div> </div> <div>/* 4030 prog
*/</div> <div>int main (int argc, char**argv) {<BR> char * buff;<BR> 
; int mbCount = 0;</div> <div> while (1) {<BR> buff =
(char *) malloc(1024*1024);<BR> if (buff == (char *)0) {<BR>
printf("Out of memory\n");<BR>
exit(0);<BR> }<BR> mbCount += 1;<BR>
printf("Allocated %d MB\n", mbCount);<BR> }<BR>}</div> <div> </div>
<div>Thanks</div>
<div>Fairlie<BR><BR><B><I>John D Parker <orclwzrd@(protected)></I></B>
wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT:
5px; BORDER-LEFT: #1010ff 2px solid">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<BR><BR><B><I>John D
Parker <orclwzrd@(protected)></I></B> wrote: <BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px
solid">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.<BR><BR>
<B><I>Tim Gorman <tim@(protected)></I></B> wrote: <BLOCKQUOTE class=replbq
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px
solid">Make sure that process limits (i.e. "ulimit -a")
for the Oracle software<BR>owner account (usually "oracle") are set as
recommended by Oracle<BR>Support, as in MetaLink note #169706.1?<BR><BR>ORA
-04030 means that the Oracle process attempted to allocate more<BR>memory for
heap, similar to using the C "malloc()" function, so process<BR>limits could be
very relevant...<BR><BR><BR><BR>John D Parker wrote:<BR>> any quick ideas on
how to fix this?<BR>><BR>> Fri Jun 2 17:07:11 2006<BR>> Doing block
recovery for file 2 block 22497<BR>> Fri Jun 2 17:07:11 2006<BR>> Errors
in file <BR>> /u01/oracle/product/10.2.0.1/EE/admin/PROD2/bdump/prod2_smon
_30391.trc:<BR>> ORA-04030 (See ORA-04030.ora-code.com): out of process memory when trying to allocate
8389132 bytes <BR>> (pga heap,redo read buffer)<BR>><BR>> __ ____ ____
__ ____ ____ ____ ____ ____ ____ _____<BR>> Do You Yahoo!?<BR>> Tired of
spam? Yahoo! Mail has the best spam protection around<BR>> http://mail.yahoo
.com<BR>><BR>>
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<BR>> Do You Yahoo!?<BR>
> Tired of spam? Yahoo! Mail has the best spam protection around<BR>> http
://mail.yahoo.com<BR>><BR><BR></BLOCKQUOTE><BR> <DIV>__ ____ ____ ____ _____
__ ____ ____ ____ ____ ____<BR>Do You Yahoo!?<BR>Tired of spam? Yahoo! Mail has
the best spam protection around <BR>http://mail.yahoo.com </DIV></BLOCKQUOTE>
<BR> <div>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<BR>Do You Yahoo!?
<BR>Tired of spam? Yahoo! Mail has the best spam protection around <BR>http:/
/mail.yahoo.com <div>__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<BR>Do
You Yahoo!?<BR>Tired of spam? Yahoo! Mail has the best spam protection around
<BR>http://mail.yahoo.com </div></BLOCKQUOTE><BR><BR><BR><DIV> <DIV> <DIV>
<DIV> <DIV> <DIV><STRONG>Fairlie Rego<BR></STRONG>Senior Oracle Consultant<
/DIV> <DIV>Optus Telecommunications</DIV> <DIV><A href="http://www.optus.com
.au/">www.optus.com.au</A></DIV> <DIV><FONT
face="comic sans ms"></FONT> </DIV></DIV></DIV></DIV></DIV></DIV><p> 
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __<br>Do You Yahoo!?<br>Tired of
spam? Yahoo! Mail has the best spam protection around <br>http://mail.yahoo
.com
|
|
