Re: Oracle Problem on AIX

marcelmix_at_yahoo.com (DBA) wrote in message news:<3607af43.0404061235.67bb5bbf_at_posting.google.com>...
> Last weekend I faced the problem of paging space filing up, wich
> caused the oracle database to be inaccessible, not only the database
> wasn't running my telnet service was down too. After rebooting the
> server everything went back to normal.
> I have about 10 instances running and those are most of all
> development instances so there is not much havy load goign on.
> The server has 8Gigs of Phisical RAM and 4Gigs of Swap space. I've
> been monitoring the server using VMSTS since but I don't see any major
> activity going on. Paging-In is at zero and the CPU is at 98% Unused
> on average.
> So what could cause the server to start paging and halt all the
> services? And how to prevent it from happenig again?
>
> Thank You

AIX & Oracle Version numbers would be nice to know. I've experienced the same issue with AIX 4.3.3 and Oracle 8.1.7.4, 9.1.0.3 & 9.2.0.4. I'm fairly certain it has nothing to do with Oracle directly, but, to do with AIX. I have not been able to pin it down. I can let my servers run for several months and then paging fills up. Monitoring paging space 'free space', I noticed no clear pattern. i.e. I'd see 30% free on a Tuesday and then see 50% free the next. I'll be upgrading to 5.2 fairly soon, hopefully it's worked out there. I've also noticed that when it fills, you might be able to telnet to it, but forget about running any kind of os command. I then have to "kick the server" to get it back(yuk I don't like the power resets without a shutdown).

HTH,
Pete's Received on Wed Apr 07 2004 - 08:16:12 CDT