Re: how to avoid paging and low memory

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