Re: how to avoid paging and low memory
- From: "Anand Rao" <panandrao@xxxxxxxxx>
- To: "Derya Oktay" <deryaoktay@xxxxxxxxx>
- Date: Tue, 17 Oct 2006 14:52:43 +0530
Those swap space recommendations were done during the Jurassic days when memory was very expensive. so, these days it is irrelevant.
primarily, an application or the system should not swap. thats the goal. talk to your sys admin and find out who is swapping/paging. do you use a very large SGA? are you using so much physical memory leaving very little room for the application or other processes?
you can stick with a minimal swap area of around 4GB or maybe 8GB max. we have large systems with 256GB and swap space of 16GB and less. for systems with 64GB, we do configure 4GB swap at times.
those Kernel params may give you a clue. follow the AIX recommendations, there are some great Red Books for performance management.
On 17/10/06, Derya Oktay <deryaoktay@xxxxxxxxx> wrote:
Hi Anand, I checked 5.3 updates from preinstallation requirements, all of them installed. But, the recommended swap space size over total 8G real memory, is adviced as (Total memory size) * 0.75. We have 64 G then, it advices 64* 0.75=48G swap space. Currently we have 4G swap space, is it really a problem? We have currently GPFS 126.96.36.199. I am waiting for th sys admin for minperm/maxperm and minfree/maxfree values. Thanks. Derya.
On 10/17/06, Anand Rao < panandrao@xxxxxxxxx> wrote: > > Derya, > > what are the values set for minperm and maxperm? Also, the values for > minfree/maxfree. these parameter should be set correctly. have a chat with > your systems administrator. > > If you are using AIX 5.3, you should have this update : IY58143. > > i read somewhere that you need to use GPFS 188.8.131.52 for AIX 5.2 and > above. Also, have you reviewed ML note 302806.1 > > do you really want to use GPFS ?? :-) > > regards > anand > > On 17/10/06, Derya Oktay <deryaoktay@xxxxxxxxx > wrote: > > > > Thanks for the replies... > > We have got Oracle 10.1.0.4 RAC database AIX 5L 64bit and GPFS 2.3. We > > upgraded our database from 9i to 10g in May 2006. We hit several bugs since > > then. > > Oracle recently advise us to apply CRS fix bundle 4731033 or 10.1.0.5 patchset, > > and look for network errors. > > I will send init.ora later, because I am not in the office right now. > > I do not know if it is related with this issue, but we got ORA-600 errors > > seldomly. > > Below our operating system logs and patch lists. > > Regards, > > Derya. > > > > Installed Patch List: > > ===================== > > 1) Patch 4281837 applied on Tue Jul 04 20:29:46 GMT+02:00 2006 > > [ Base Bug(s): 3668164 ] > > /kpoci.o --> /oracle/product/10g/lib/libserver10.a > > > > 2) Patch 4427729 applied on Thu Jan 26 21:32:32 GMT+02:00 2006 > > [ Base Bug(s): 3515102 ] > > /clsrc.o --> /oracle/product/10g/lib/libclsr10.a > > /clsrcact.o --> /oracle/product/10g/lib/libclsr10.a > > > > 3) Patch 4382045 applied on Thu Jan 26 17:03:25 GMT+02:00 2006 > > [ Base Bug(s): 4382045 ] > > > > So CRS bundle is not applied. > > Hdr: 4731033 10.1.0.4 PCW 10.1.0.4 PRODID-5 PORTID-46 > > Abstract: PLACEHOLDER BUG FOR PCW 10.1.0.4 BUNDLE FOR VARIOUS > > COMPONENTS > > > > > > > > On 10/16/06, Mladen Gogala <mgogala@xxxxxxxxxxx> wrote: > > > > > > > > > On 10/16/2006 09:17:42 AM, Derya Oktay wrote: > > > > Our Oracle 2 node RAC and each having 4G paging space, and 60G > > > RAM was fed > > > > up by Oracle processes. > > > > The problem first started first node and then spread out to the > > > second node. > > > > It continued till we restarted our servers. > > > > How can I avoid this kind of memory problem? > > > > Thanks. Regards, > > > > Derya. > > > > > > > > > > > > > Which OS? If Linux, I have a paper about it on my site. > > > -- > > > Mladen Gogala > > > http://www.mladen-gogala.com > > > > > > > > > > > -- > All I need to make a comedy is a park, a policeman and a pretty girl - > Charlie Chaplin
-- All I need to make a comedy is a park, a policeman and a pretty girl - Charlie Chaplin