From: Hunter, Mark (Mark.Hunter@ANHEUSER-BUSCH.COM)
Date: Mon Jun 30 2003 - 10:18:22 EDT
Need more information to even guess where to start.
1. ML11 has an aio patch oracle needs. Should look at going to it soon.
2. Send results of a vmstat 5 5
3. ipcs -bm
4. lsps -s
5. vmtune
6. lsattr -E -l aio0
Typical answer here would be the Oracle DBAs setting their SGA too large and
eating all memory. 8GB of RAM is not that much for a 1 TB database. You should
tune down max and min perm so that you don't double buffer. Have you gone the
the guide to configure AIX for oracle? There is a white paper or a red book,
don't remember which.
-----Original Message-----
From: Spencer Johnson [mailto:Spencer.Johnson@2020LOG.COM]
Sent: Monday, June 30, 2003 8:49 AM
To: aix-l@Princeton.EDU
Subject: S85 not quite right !!
Hi list,
I have a slight problem / issue, this is related to an 7017-S85 server,
connected to F20 ESS. The server is a 6W - 8 GB RAM running Oracle 8.1.7.4 with
database instance of approx. 1 TB.
The problem is that most operations (coping files, etc) cause the system to page
and send the CPU's into Wait state constantly, I have logged a call with IBM and
they have
come back with a few suggestions of changing vmtune parameters.
Oracle is tuned to allow for 6W processors but I feel that the O/S is being
restricted by something. The disks do not perform that much work (only 50% busy
at max).
The O/S is currently at 4.3.3 ML 10, but am considering going to ML 11.
Has anyone out there had similar experiences and how have they been overcome.
Spencer Johnson
***************************************************************
Disclaimer :-
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions are solely
those of the author and do not necessarily represent those of
20:20 Logistics Ltd, Dextra Accessories Ltd,
The Discovery Store Ltd and The Mobile Phone Repair Company Ltd.
If you are not the intended recipient, be advised that you have
received this email in error and that any use, dissemination,
forwarding, printing or copying is strictly prohibited. If you
have received this email in error please delete it from your system
and notify the sender immediately.
***************************************************************
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:58 EDT