QUESTION POSED ON: 25 January 2007
Hi Paul,
I am developer and I am in the process of implementing a third-party
application that was developed with an Oracle back end running on
Windows. At our company, Oracle is running on Unix. We are running
into performance issues with some SQL queries. I believe that these
queries are dynamic SQL queries. When executing these queries on
Windows Oracle, it took two seconds. On Unix Oracle, it took nearly seven
minutes. I am at a loss as is our DBA. On the Unix box, I was told
that we have a big box, 8 CPU with 266 MHz RAM speed and 64 GB of RAM.
On the Windows 2003 platform, we have a 3 GHz with 8 GB of RAM at a
speed of 600 Mhz.
- Obviously, the hardware setups are very different, but could this have
caused such a wide difference in performance?
- Are there any performance-related issues that are specific to the two
platforms that we should watch out for and ways to mitigate the issues?
- I am not a hardware expert but is the RAM speed above sufficient for
the Unix box?
Thank you in advance!
|
