  | | | "Out of Memory: Killed process " errors on server running Oracle | "Out of Memory: Killed process " errors on server running Oracle 2007-07-13 - By David.Knight@(protected)
Back How fragmented is the file system. Oracle needs contiguous free space to for it's next extents. open up ocfstool and see what your contiguous free space looks like compared to what size your next extent are.
Gene <gene@(protected)> Sent by: taroon-list-bounces@(protected) 07/13/2007 10:21 AM Please respond to "Discussion of Red Hat Enterprise Linux 3 (Taroon)" <taroon-list@(protected)>
To "Discussion of Red Hat Enterprise Linux 3 (Taroon)" <taroon-list@(protected)> cc
Subject Re: "Out of Memory: Killed process" errors on server running Oracle
We are running OCFS and have plenty of disk space. Is there anything in specific I need to check in SGA?
-Gene
On 7/13/07, David.Knight@(protected) <David.Knight@(protected)> wrote:
What is the status if the SGA in oracle? are you running ocfs? do you have plenty of disk space?
Gene <gene@(protected)> Sent by: taroon-list-bounces@(protected) 07/12/2007 04:17 PM
Please respond to "Discussion of Red Hat Enterprise Linux 3 (Taroon)" < taroon-list@(protected)>
To "Discussion of Red Hat Enterprise Linux 3 (Taroon)" < taroon-list@(protected)> cc
Subject "Out of Memory: Killed process" errors on server running Oracle
Hola,
Every 5-6 days I'm getting "Out of Memory: Killed process" messages on a Redhat AS 3 server running Oracle 9.20. These errors will occur for a couple hours and will eventually lead to Oracle shutting down. The load on the server did increase recently, but there's still 1.8GB memory free on the system during these errors.
The box is running the smp kernel. Should I do something like increase the stack size or use the hugemem kernel?
$ uname -a Linux prddb02 2.4.21-15.0.3.ELsmp #1 SMP Tue Jun 29 18:04:47 EDT 2004 i686 i686 i386 GNU/Linux
$ ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (blocks, -f) unlimited max locked memory (kbytes, -l) 4 max memory size (kbytes, -m) unlimited open files (-n) 65536 pipe size (512 bytes, -p) 8 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 16384 virtual memory (kbytes, -v) unlimited
>From /var/log/messages:
Jul 11 19:06:31 prddb02 kernel: Mem-info: Jul 11 19:06:31 prddb02 kernel: Zone:DMA freepages: 2549 min: 0 low: 0 high: 0 Jul 11 19:06:31 prddb02 kernel: Zone:Normal freepages: 1254 min: 1279 low: 4544 high: 6304 Jul 11 19:06:31 prddb02 kernel: Zone:HighMem freepages:501745 min: 255 low: 20992 high: 31488 Jul 11 19:06:31 prddb02 kernel: Free pages: 505548 (501745 HighMem) Jul 11 19:06:31 prddb02 kernel: aa:0 ac:0 id:0 il:0 ic:0 fr:2549 Jul 11 19:06:31 prddb02 kernel: aa:0 ac:40 id:82 il:73 ic:0 fr:1254 Jul 11 19:06:31 prddb02 kernel: aa:530276 ac:82904 id:17203 il:6249 ic:8419 fr:501745 Jul 11 19:06:31 prddb02 kernel: 1*4kB 2*8kB 2*16kB 1*32kB 0*64kB 1*128kB 1*256kB 1*512kB 1*1024kB 0*2048kB 2*4096kB = 10196kB) Jul 11 19:06:31 prddb02 kernel: 137*4kB 121*8kB 45*16kB 19*32kB 6*64kB 2*128kB 0*256kB 1*512kB 1*1024kB 0*2048kB 0*4096kB = 5020kB) Jul 11 19:06:31 prddb02 kernel: 35001*4kB 11806*8kB 4209*16kB 1479*32kB 1490*64kB 513*128kB 291*256kB 48*512kB 15*1024kB 5*2048kB 335*4096kB = 2006980kB) Jul 11 19:06:31 prddb02 kernel: Swap cache: add 0, delete 0, find 0/0, race 0+0 Jul 11 19:06:31 prddb02 kernel: 192549 pages of slabcache Jul 11 19:06:31 prddb02 kernel: 1192 pages of kernel stacks Jul 11 19:06:31 prddb02 kernel: 0 lowmem pagetables, 127372 highmem pagetables Jul 11 19:06:31 prddb02 kernel: Free swap: 8192980kB Jul 11 19:06:31 prddb02 kernel: 1572864 pages of RAM Jul 11 19:06:31 prddb02 kernel: 1277920 pages of HIGHMEM Jul 11 19:06:31 prddb02 kernel: 89860 reserved pages Jul 11 19:06:31 prddb02 kernel: 24863915 pages shared Jul 11 19:06:31 prddb02 kernel: 0 pages swap cached Jul 11 19:06:31 prddb02 kernel: Out of Memory: Killed process 8302 (oracle).
$ sar -r -f /var/log/sa/sa11 10:00:00 AM kbmemfree kbmemused %memused kbbuffers kbcached kbswpfree kbswpused %swpused kbswpcad 05:00:00 PM 1901836 4030180 67.94 4228 1976412 8192980 0 0.00 0 05:10:00 PM 1755672 4176344 70.40 1456 2115832 8192980 0 0.00 0 05:20:00 PM 1901120 4030896 67.95 2952 1976168 8192980 0 0.00 0 05:30:00 PM 1896664 4035352 68.03 2392 1975920 8192980 0 0.00 0 05:39:59 PM 1892232 4039784 68.10 2200 1975900 8192980 0 0.00 0 05:50:00 PM 1889808 4042208 68.14 2408 1976076 8192980 0 0.00 0 06:00:00 PM 1897984 4034032 68.00 2336 1976244 8192980 0 0.00 0 06:10:00 PM 1831708 4100308 69.12 1192 2040788 8192980 0 0.00 0 06:20:01 PM 1832808 4099208 69.10 1372 2040912 8192980 0 0.00 0 06:30:03 PM 1844548 4087468 68.91 1284 2040988 8192980 0 0.00 0 06:40:01 PM 1895092 4036924 68.05 1304 2041120 8192980 0 0.00 0 06:50:00 PM 1909852 4022164 67.80 1300 2041248 8192980 0 0.00 0 07:00:01 PM 1906980 4025036 67.85 1104 2041300 8192980 0 0.00 0 07:10:01 PM 4363412 1568604 26.44 13816 726432 8192980 0 0.00 0
-Gene
gene@(protected) Taroon-list mailing list Taroon-list@(protected) https://www.redhat.com/mailman/listinfo/taroon-list
-- Taroon-list mailing list Taroon-list@(protected) https://www.redhat.com/mailman/listinfo/taroon-list -- Taroon-list mailing list Taroon-list@(protected) https://www.redhat.com/mailman/listinfo/taroon-list
<br><font size=2 face="sans-serif">How fragmented is the file system. Oracle needs contiguous free space to for it's next extents. open up ocfstool and see what your contiguous free space looks like compared to what size your next extent are.</font> <br> <br> <br> <br> <table width=100%> <tr valign=top> <td width=40%><font size=1 face="sans-serif"><b>Gene <gene@(protected)></b> </font> <br><font size=1 face="sans-serif">Sent by: taroon-list-bounces@(protected)< /font> <p><font size=1 face="sans-serif">07/13/2007 10:21 AM</font> <table border> <tr valign=top> <td bgcolor=white> <div align=center><font size=1 face="sans-serif">Please respond to<br> "Discussion of Red Hat Enterprise Linux 3 (Taroon)" <taroon-list @(protected)></font></div></table> <br> <td width=59%> <table width=100%> <tr valign=top> <td> <div align=right><font size=1 face="sans-serif">To</font></div> <td><font size=1 face="sans-serif">"Discussion of Red Hat Enterprise Linux 3 (Taroon)" <taroon-list@(protected)></font> <tr valign=top> <td> <div align=right><font size=1 face="sans-serif">cc</font></div> <td> <tr valign=top> <td> <div align=right><font size=1 face="sans-serif">Subject</font></div> <td><font size=1 face="sans-serif">Re: "Out of Memory: Killed process" errors on server running Oracle</font></table> <br> <table> <tr valign=top> <td> <td></table> <br></table> <br> <br> <br><font size=3>We are running OCFS and have plenty of disk space. Is there anything in specific I need to check in SGA?<br> <br> -Gene<br> </font> <br><font size=3>On 7/13/07, </font><a href=mailto:David.Knight@(protected)> <font size=3 color=blue><b><u>David.Knight@(protected)</u></b></font></a><font size=3> <</font><a href=mailto:David.Knight@(protected)><font size=3 color=blue><u >David.Knight@(protected)</u></font></a><font size=3>> wrote:</font> <br><font size=2 face="sans-serif"><br> What is the status if the SGA in oracle? are you running ocfs? do you have plenty of disk space?</font><font size=3> <br> <br> </font> <table width=100%> <tr valign=top> <td width=47%><font size=1 face="sans-serif"><b>Gene <</b></font><a href =mailto:gene@(protected) target=_blank><font size=1 color=blue face="sans-serif"> <b><u>gene@(protected)</u></b></font></a><font size=1 face="sans-serif"><b>></b > <br> Sent by: </font><a href="mailto:taroon-list-bounces@(protected)" target=_blank> <font size=1 color=blue face="sans-serif"><u>taroon-list-bounces@(protected)</u>< /font></a><font size=3> </font> <p><font size=1 face="sans-serif">07/12/2007 04:17 PM</font><font size=3> </font> <br> <table border=4 width=100%> <tr valign=top> <td width=100% bgcolor=white> <div align=center><font size=1 face="sans-serif">Please respond to<br> "Discussion of Red Hat Enterprise Linux 3 (Taroon)" <</font><a href="mailto:taroon-list@(protected)" target=_blank><font size=1 color=blue face ="sans-serif"><u>taroon-list@(protected)</u></font></a><font size=1 face="sans -serif">></font></div></table> <p> <td width=52%> <br> <table width=100%> <tr valign=top> <td width=9%> <div align=right><font size=1 face="sans-serif">To</font></div> <td width=90%><font size=1 face="sans-serif">"Discussion of Red Hat Enterprise Linux 3 (Taroon)" <</font><a href="mailto:taroon-list@(protected) .com" target=_blank><font size=1 color=blue face="sans-serif"><u>taroon-list @(protected)</u></font></a><font size=1 face="sans-serif">></font><font size=3 > </font> <tr valign=top> <td> <div align=right><font size=1 face="sans-serif">cc</font></div> <td> <tr valign=top> <td> <div align=right><font size=1 face="sans-serif">Subject</font></div> <td><font size=1 face="sans-serif">"Out of Memory: Killed process" errors on server running Oracle</font></table> <br> <br> <table width=100%> <tr valign=top> <td width=50%> <td width=50%></table> <br></table> <br><font size=3><br> <br> <br> Hola,<br> <br> Every 5-6 days I'm getting "Out of Memory: Killed process" messages on a Redhat AS 3 server running Oracle 9.20. These errors will occur for a couple hours and will eventually lead to Oracle shutting down. The load on the server did increase recently, but there's still 1.8GB memory free on the system during these errors.<br> <br> The box is running the smp kernel. Should I do something like increase the stack size or use the hugemem kernel?<b><br> <br> $ uname -a </b><br> Linux prddb02 2.4.21-15.0.3.ELsmp #1 SMP Tue Jun 29 18:04:47 EDT 2004 i686 i686 i386 GNU/Linux<b><br> <br> $ ulimit -a</b><br> core file size (blocks, -c) 0<br> data seg size (kbytes, -d) unlimited <br> file size (blocks, -f) unlimited<br> max locked memory (kbytes, -l) 4<br> max memory size (kbytes, -m) unlimited<br> open files (-n) 65536<br> pipe size (512 bytes, -p) 8 <br> stack size (kbytes, -s) 10240<br> cpu time (seconds, -t) unlimited<br> max user processes (-u) 16384<br> virtual memory (kbytes, -v) unlimited<b><br> <br> >From /var/log/messages:</b><br> <br> Jul 11 19:06:31 prddb02 kernel: Mem-info:<br> Jul 11 19:06:31 prddb02 kernel: Zone:DMA freepages: 2549 min: 0 low: 0 high: 0<br> Jul 11 19:06:31 prddb02 kernel: Zone:Normal freepages: 1254 min: 1279 low: 4544 high: 6304 <br> Jul 11 19:06:31 prddb02 kernel: Zone:HighMem freepages:501745 min: 255 low: 20992 high: 31488<br> Jul 11 19:06:31 prddb02 kernel: Free pages: 505548 (501745 HighMem)<br> Jul 11 19:06:31 prddb02 kernel: aa:0 ac:0 id:0 il:0 ic:0 fr:2549 <br> Jul 11 19:06:31 prddb02 kernel: aa:0 ac:40 id:82 il:73 ic:0 fr:1254<br> Jul 11 19:06:31 prddb02 kernel: aa:530276 ac:82904 id:17203 il:6249 ic:8419 fr:501745<br> Jul 11 19:06:31 prddb02 kernel: 1*4kB 2*8kB 2*16kB 1*32kB 0*64kB 1*128kB 1*256kB 1*512kB 1*1024kB 0*2048kB 2*4096kB = 10196kB) <br> Jul 11 19:06:31 prddb02 kernel: 137*4kB 121*8kB 45*16kB 19*32kB 6*64kB 2*128kB 0*256kB 1*512kB 1*1024kB 0*2048kB 0*4096kB = 5020kB)<br> Jul 11 19:06:31 prddb02 kernel: 35001*4kB 11806*8kB 4209*16kB 1479*32kB 1490*64kB 513*128kB 291*256kB 48*512kB 15*1024kB 5*2048kB 335*4096kB = 2006980kB) <br> Jul 11 19:06:31 prddb02 kernel: Swap cache: add 0, delete 0, find 0/0, race 0+0<br> Jul 11 19:06:31 prddb02 kernel: 192549 pages of slabcache<br> Jul 11 19:06:31 prddb02 kernel: 1192 pages of kernel stacks<br> Jul 11 19:06:31 prddb02 kernel: 0 lowmem pagetables, 127372 highmem pagetables <br> Jul 11 19:06:31 prddb02 kernel: Free swap: 8192980kB<br> Jul 11 19:06:31 prddb02 kernel: 1572864 pages of RAM<br> Jul 11 19:06:31 prddb02 kernel: 1277920 pages of HIGHMEM<br> Jul 11 19:06:31 prddb02 kernel: 89860 reserved pages <br> Jul 11 19:06:31 prddb02 kernel: 24863915 pages shared<br> Jul 11 19:06:31 prddb02 kernel: 0 pages swap cached<br> Jul 11 19:06:31 prddb02 kernel: Out of Memory: Killed process 8302 (oracle).<b> <br> <br> $ sar -r -f /var/log/sa/sa11</b></font><font size=2 face="Courier"><br> 10:00:00 AM kbmemfree kbmemused %memused kbbuffers kbcached kbswpfree kbswpused %swpused kbswpcad<br> 05:00:00 PM 1901836 4030180 67.94 4228 1976412 8192980 0 0.00 0<br> 05:10:00 PM 1755672 4176344 70.40 1456 2115832 8192980 0 0.00 0<br> 05:20:00 PM 1901120 4030896 67.95 2952 1976168 8192980 0 0.00 0<br> 05:30:00 PM 1896664 4035352 68.03 2392 1975920 8192980 0 0.00 0<br> 05:39:59 PM 1892232 4039784 68.10 2200 1975900 8192980 0 0.00 0 <br> 05:50:00 PM 1889808 4042208 68.14 2408 1976076 8192980 0 0.00 0<br> 06:00:00 PM 1897984 4034032 68.00 2336 1976244 8192980 0 0.00 0<br> 06:10:00 PM 1831708 4100308 69.12 1192 2040788 8192980 0 0.00 0<br> 06:20:01 PM 1832808 4099208 69.10 1372 2040912 8192980 0 0.00 0<br> 06:30:03 PM 1844548 4087468 68.91 1284 2040988 8192980 0 0.00 0<br> 06:40:01 PM 1895092 4036924 68.05 1304 2041120 8192980 0 0.00 0 <br> 06:50:00 PM 1909852 4022164 67.80 1300 2041248 8192980 0 0.00 0<b><br> 07:00:01 PM 1906980 4025036</b> 67.85 1104 2041300 8192980 0 0.00 0<b><br> 07:10:01 PM 4363412 1568604</b> 26.44 13816 726432 8192980 0 0.00 0</font><font size=3><br> <br> -Gene</font> <br><font size=3 color=blue><u><br> </u></font><a href=mailto:gene@(protected) target=_blank><font size=3 color=blue> <u>gene@(protected)</u></font></a><font size=2><tt>--<br> Taroon-list mailing list</tt></font><font size=2 color=blue><tt><u><br> </u></tt></font><a href="mailto:Taroon-list@(protected)" target=_blank><font size=2 color=blue><tt><u>Taroon-list@(protected)</u></tt></font></a><font size=2 color=blue><tt><u><br> </u></tt></font><a href="https://www.redhat.com/mailman/listinfo/taroon-list" target=_blank><font size=2 color=blue><tt><u>https://www.redhat.com/mailman /listinfo/taroon-list</u></tt></font></a><font size=3> <br> <br> --<br> Taroon-list mailing list</font><font size=3 color=blue><u><br> </u></font><a href="mailto:Taroon-list@(protected)"><font size=3 color=blue><u >Taroon-list@(protected)</u></font></a><font size=3 color=blue><u><br> </u></font><a href="https://www.redhat.com/mailman/listinfo/taroon-list" target =_blank><font size=3 color=blue><u>https://www.redhat.com/mailman/listinfo /taroon-list</u></font></a> <br><font size=2><tt>--<br> Taroon-list mailing list<br> Taroon-list@(protected)<br> https://www.redhat.com/mailman/listinfo/taroon-list</tt></font> <br> -- Taroon-list mailing list Taroon-list@(protected) https://www.redhat.com/mailman/listinfo/taroon-list
|
|
 |