Does CPU performance has great impact of Oracle 9i performance?
I am evaluating two machines. One is P4, 3.2 GHz with 1 GB RAM. The other one in P4, 2.26 Ghz with 512 M RAM. How can I show that the first one is better than the other in using Oracle?
I can't do any test, because I don't have the machines. We are planning to buy one of them. Of course, I want to buy M1, but my boss would ask me "why". Therefore, I would like to know the impact of CPU in using Oracle.
Originally posted by alisonhui Does CPU performance has great impact of Oracle 9i performance?
In a properly tuned OLTP system, you would not see much difference in a 2.4Ghz and a 3.2 Ghz box. Most likely your biggest bottleneck will be I/O throughput. In a poorly tuned system, yes, CPU speed does matter.