From: support (support@xiatecs.net)
Date: Sat Oct 26 2002 - 19:41:56 EDT
Hi,
When you say the CPU utilization is at 100% what is the break down of the
utilization in US% SY% and WIO% (vmstat output would be helpful). Also if
you can post the output of the highest processes that utilizing the CPU :
ps aux | grep -v kproc | sort -r -k 3 | head
Regarding your new system in mind 6H1. I will personally go with the 6x750
MHz CPUs. As I find, from experience working with Oracle, that it need a lot
of CPU.
XiaTecs Support Team
support@xiatecs.net
www.xiatecs.net
-----Original Message-----
From: IBM AIX Discussion List [mailto:aix-l@Princeton.EDU]On Behalf Of
Theresa Sarver
Sent: Friday, October 25, 2002 5:44 PM
To: aix-l@Princeton.EDU
Subject: Help spec'ing out a new server
Hi all;
This is a rather odd post, but I'm looking for a little guidence in picking
out a new Oracle database server. I'll tell you what I have in mind and I'd
appreiate any advice on the matter.
As is now we have an SP node with the following spec's:
4-375Mhz CPU's
4GB RAM
2GB Paging
Running the following databases:
NAME USERS SIZE SGA [total] Size in 3 years
DB1 1500 100GB 500MB Double in size
DB2 80 10GB 115MB Double in size
DB3 70 4GB 80MB Double in size
This node sits at 100% CPU utilization almost constantly. Paging isn't a
big constant issue, though depending on what the users are doing then it
becomes one. The DBA's and I have worked nearly every angle and we cannot
get the CPU utilization to drop. Oh, and FYI...we're looking to upgrade to
Oracle 9i fairly soon and I can't find a whole lot of info on any additional
overhead the 9i product may have.
Anyway, I've been told to spec out a new [IBM] server, I had the P660-6H1 in
mind w/ 6-750Mhz (would 600 MHz suffice? - or for that matter could I get
away with 4-750Mhz processers?) processors and 8 GB of RAM. Does this sound
like it would work okay? Does anyone have any other suggestions or
recommendations? I'm just not real familiar with Oracle and what it
requires to be happy.
Thanks in advance for your help;
Theresa
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:17 EDT