Operating System - HP-UX
1748161 Members
3911 Online
108758 Solutions
New Discussion юеВ

Re: oracle itanium vs. pa-risc performance

 
SOLVED
Go to solution
Julio Yamawaki
Esteemed Contributor

Re: oracle itanium vs. pa-risc performance

Hi,

I installed a rx-2600 with 800 MHz Itanium with Oracle 9.2.0.2 and about 120 users.
I installed a rp-3410 with 800 MHz PA-8800 with Oracle 9.2.0.0 and about 100 users.
Some key issues:
1. Oracle installation: 15 minutes in Itanium, 23 minutes in PA-RISC
2. Import: 50 GB base in Itanium: 2,5 hours, 45 GB in PA-Risc: 3 hours
All disks area 15K rpm, 3 GB memory in each case.
So, my conclusion is that Oracle in Itanium has more performance than in PA-Risc.

Regards,
Tony Drake_2
Frequent Advisor

Re: oracle itanium vs. pa-risc performance

Thanks. That's great.

If anyone else has any similar numbers I'd like to see them.

Steven E. Protter
Exalted Contributor

Re: oracle itanium vs. pa-risc performance

Reality check:

Julio Yamawaki, conclusion should be "comparable"

The speed of the i/o on the bus on those two systems may be different, as the system boards are different.

Based on the fact that the data loads are not the same size, the test can not conclude that either platform is faster.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Tony Drake_2
Frequent Advisor

Re: oracle itanium vs. pa-risc performance

I realize the differences Steven. Although the two systems are not completely identical, and there are differences between ITanium and PA RISC system boards, this does tell me that the two are just that, comparable.

I intend to do some benchmarking of our own, but I wanted to see if anyone had any data so I would know what to expect.

Thanks.
Tony
Geoff Wild
Honored Contributor

Re: oracle itanium vs. pa-risc performance

I was told by our account rep, that on comparable servers (PARISC to Itanium ), that you could half the cpus and get about the same performance.

IE: 4 X CPU RP about the same as 2 X CPU RX....

I have not seen any stats to validate this....

RGds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Hein van den Heuvel
Honored Contributor

Re: oracle itanium vs. pa-risc performance

The 'best' PA is pretty close to a lowest IPF.
A recent box with (1.5 or 1.6 Ghz, 9Mb cache) Itanium can often double the performance when replacing a somewhat older PS system with the same mount of processors.

One proof point

http://www50.sap.com/benchmark/sd2tier.asp -->
All 8-way SMP, Oracle 9i, HPUX 11i. All tests in a few months time span, and by the same team so rather compareable.


Date-------SD Users---Model
01/12/2004 1240 rp4440, PA-8800 1.0 GHz
09/12/2003 1500 rx7620, Intel Itanium 2, 1.5 GHz
04/29/2004 1320 rx4640-8, 4 HP mx2 dual 1.1 GHz Itanium


http://www.tpc.org/tpcc/results/tpcc_results.asp?orderby=hardware

07/30/03 541,674 64* HP PA-RISC 8700 875MHz
11/04/03 1,008,144 64*Intel Itanium2 1.5GHz


hth,
Hein.




Alzhy
Honored Contributor

Re: oracle itanium vs. pa-risc performance

Interesting SAP benchmarks Hein.

It looks like an 8-way PA8800 1.0Ghz performed at par with an 8-way Intanium2 boxen when doing the SAP benchmarks:

http://www50.sap.com/benchmark/pdf/cert0104.pdf
http://www50.sap.com/benchmark/pdf/cert3704.pdf


Hakuna Matata.
Geoff Wild
Honored Contributor

Re: oracle itanium vs. pa-risc performance

Actually, Nelson's compares Windoze to HP-UX - different classes RX76xx to RP44xx

This is better:

4way Itanium, HPUX, RX4640
http://www50.sap.com/benchmark/pdf/cert3004.pdf

to a

8way PARISC, HPUX, RP4440
http://www50.sap.com/benchmark/pdf/cert0104.pdf

Performance very close...

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Steven E. Protter
Exalted Contributor

Re: oracle itanium vs. pa-risc performance

As I also forgot to mention.

800 Megahertz on PA-RISC is not the same as 800 Megahertz on Itanium.

RISC has different(reduced) Instruction set.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Florian Heigl (new acc)
Honored Contributor

Re: oracle itanium vs. pa-risc performance

Steven - I think the Itanium is a risc cpu, are You sure it isn't?

(I don't like it anyway. Currently at our site it's ~500/4 hppa/ipf and it's good that way.)
yesterday I stood at the edge. Today I'm one step ahead.