CPU speed comparison

Hi Gurus,

Firstly Wish you all Merry Christmas.

   We have a banking application and I am in the process of doing a CPU Capacity prediction of the DB server based on the Ratio Modelling Technique. I have arrived at the CPU requirements for particular platform(Say Itanium2) and now I want to arrive at the CPU numbers for the other Server platforms(PA-RISC, IBM PowerV/VI, Intel Xeon, Ultrasparc IV/III).

Say for a given volume set I arrive at a 2 CPU Itanium2, Now how do I arrive at CPU numbers for the other platforms. Any inputs/pointers would very much be appriciated.

I looked at http://home.comcast.net/~arivenes/sql/cpu_test.sql and feel that we can use this script for the said comparison provided the underying assumption is correct. The scripts basic assumption is using LIO's to determine the CPU usage . Run this script in various platforms and use the CPU usage figure across platforms to arrive at the comparitive numbers. Does this approach sound logical?

In this effect, I remembered rading Cary's papaer "Why You Should Focus on LIOs Instead of PIOs" and I found the following comment from the author

The actual *use *of Oracle block content is the number one consumer of CPU capacity on any reasonably well optimized Oracle system. Your average LIO latency will vary, depending primarily upon your CPU speed and the total number of machine instructions required to parse the content of an Oracle block

Thanks and Regards

Sriram Kumar Received on Fri Dec 23 2005 - 19:07:15 CST