Re: how to avoid paging and low memory

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 2.3.0.7.
I am waiting for th sys admin for minperm/maxperm and minfree/maxfree values.
Thanks.
Derya.

On 10/17/06, Anand Rao <panandrao_at_gmail.com> 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 2.3.0.1 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_at_gmail.com> 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_at_verizon.net> 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

--
http://www.freelists.org/webpage/oracle-l