Oracle server performance on different CPUs

From: Sasha Ostojic <sasha_at_UltimateTech.com>
Date: 1997/10/15
Message-ID: <6238kc$4bd$1@news-sj-3.cisco.com>#1/1

Is it possible to guesstimate (ballpark) the performance gain achieved by moving an application from one processor to another?

Say I have a simple Pro*C program that inserts 3000 records into a local database , and it takes 40 seconds to complete on a Sun UltraSparc-1 workstation with a 167MHz CPU, 128MB RAM. No computations are performed, just straight inserts. What performance gain should I expect if I were to upgrade to a faster processor, leaving everything else constant (same disks, same table layout, same memory, etc.)? Does Oracle (or Sun) provide any guidelines?

Other than testing my application on different CPUs, isn't there a way to project performance? I know that I can't expect to half the execution time by doubling the processor speed, but what should I expect?

Thanks in advance for any help or ideas.

Regards,
.sasha Received on Wed Oct 15 1997 - 00:00:00 CDT