Re: "SYSTEM RUNNING OUT OF PAGING SPACE" (AIX-HACMP-Oracle)

To : Arne S

We are experiencing the same problem on an S85 running AIX maint level 09. Oracle version is 817 . This box has 24GB of Ram and is a 12 way the performance has been horrible with the 817 database. Tests that we performed months ago on 734 were 40 percent faster .

Here is what we have found and done in order of what had the best impact;

1. Recalc the Oracle stats 3 times a day (This has helped tremendously) Why the stats are getting blown is beyond us and beyond Oracle at this point.In the past stats were only calculated monthly
2. Oracle patched to level 8.1.7.3
3. IBM performance tuned based on performance (perfpmr) taken at peak times and sent to IBM . They had us make vmstat , syncd changes.
4. We did update the bos.rte.libc to the latest level but our problem did not seem to be a memory leak.

The re-calc of the stats in oracle seems to have the biggest impact on our situation. Why we have to do it so often is still a mystery.

Any feedback you have found would also be appreciated ... Received on Mon Apr 29 2002 - 12:29:37 CDT