Re: Which platform is better?

Paul

FYI: I have worked with both Microsoft Intel and AIX based Oracle dB's.

I'd suggest sticking with option 1. But get a good Oracle DBA to check the system over. There are lots of different reasons why your system may be running bad and I'd get a tune up before spending money changing machines.

Roughly speaking for RISC based machines you can multiply the CPU power by 1.5 to get the equivalent Intel required. So your AIX is IMHO equivalent to a triple 500Mhz CPU Xeon or as they don't do triples a dual 750Mhz.... so in fact I would consider what your going to a down grade.

To work out if your machine is running out of CPU use top and examine the CPU utilisation and the run queue. Save money on an AIX expert up IBM and ask them on the phone if the figures you are getting are bad or not!

Something I did notice is that under option 2 you are talking about RAID 10, I hope you mean RAID 0+1 as any other form of RAID will impact your database's performance. Correct choice of disk and layout of Oracle files can make a massive difference to performance.At the very least get your logfiles off on to a separate mirrored disk volume!

Regards

Fraser McCallum
MVP Oracle
www.brainbench.com

"Paul R. Johnson" <pjohnson_at_take.this.out.spasydell.net> wrote in message news:8nulgtkn24li454dfib8jhaqvhn2lkkn9g_at_4ax.com...
> I currently am running Oracle 7.3.4 on AIX 4.3.1.0. We have this on a
> 3 processor 333mhz RS/6000 with 1gb ram. We a having occasional
> problems with performance, but nothing too bad. We are running a
> Point of Sale and scheduling application from Windows Terminal Server.
> There are usually 80-100 concurrent users on the system with only
> about half of them banging on it.
>
> Our lease is up on the RS/6000 and we are considering 2 options:
>
> 1. Have an AIX expert audit the system for performance and add
> memory, disks, etc as necessary. Then have an Oracle DBA do the same.
> I am currently using a contract DBA. I think that we can get more out
> of this machine.
>
> 2. Buy an new NT/2000 server. This is where I would know what I was
> talking about and able to make recommendations. I am looking at a
> dual Xeon 700mhz/1mb cache, 2+gb ram, 8 9gb hard drives configured for
> RAID 10. This should be a speedy box.
>
> We are probably going to migrate to 8.x in the near future. Which is
> better for the oracle version that we have now and the future?
>
> Thanks for your help,
>
> Paul
>
>
> Paul R. Johnson
> IT Manager
> Spa Sydell
> pjcace at yahoo dot com
>
Received on Thu May 24 2001 - 02:09:40 CEST