Re: how to avoid paging and low memory

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.5patchset, 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
>
>

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