Help spec'ing out a new server

From: Theresa Sarver (IFMC.tsarver@SDPS.ORG)
Date: Fri Oct 25 2002 - 17:43:42 EDT


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