Hey Toasters, I have a situation that has come up where we are testing Oracle 9i on a 2.4 GHz Intel Xeon system with Red Hat Enterprise Linux 3.0 as the operating system. The database itself resides on a NetApp filer. We have run through the normal problems, switching to NFS over TCP rather than UDP, no asynch I/O, not as much like Solaris as we expected, but now we're still not seeing the level of performance that we had expected. Our test database run on a Sun 280R takes about 2 hours; the same test run on our Linux system takes about 2:40. Definitely not the results we had expected. I was just wondering if anyone out there has done something similar and has any tuning recommendations. Oracle tells us that it should work fine on Linux, and we know our other databases work fine running off filers, so that leaves us with a solution that should work, but doesn't. Any recommendations, white papers, or RTFM (as long as you indicate which manual), would be greatly appreciated.
Geoff Hardin UNIX System Administrator Dallas Semiconductor geoff.hardin@dalsemi.com