Re: how to avoid paging and low memory

  • From: "Anand Rao" <panandrao@xxxxxxxxx>
  • To: deryaoktay@xxxxxxxxx
  • Date: Tue, 17 Oct 2006 08:31:30 +0530

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@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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2006