i have since days the following CPU Problem. Maybe somebody can help !
We have an oracle database 10.2.0.3 Patch 9 on two enviroments who runs Windows 2003 SP2.
The Databases are the same.
On the first Machine we have the following hardware
System Model ProLiant DL580 G3
4 x Processors Intel Xeon 3.667 GH (each cpu has 1 core. hyperthreading was activated)
Memory 10 GB
On the second Server
System Model ProLiant DL385 G2
2 x Processors AMD Opteron 2.8GH Model 1 Stepping 3 (Each Processor has two cores)
Memory 8 GB
I run a sql statement on the two Databases an the timing result is the following.
For the Intel Xeon Enviroment the total alapsed time was 24,127 (ms)
for the Amd enviroment the Elapsed time was 9,697 (ms).
Now the internal customer wants that we change the hardware and use the AMD Processor.
Give it a reason for this poor performance ? Any hints about how i can make the cpu's faster ?
thanks in advance
The AWR Report shows me that the SQL Statements use the same execution path.