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?