I've had several people ask for more details about the configuration:
Network:
100 Mb switched network full duplex
Filer:
F760C with ONTAP 6.4.1
Database Server:
RHEL Kernel 2.4.21-9.EL
1 GB of RAM; (we're trying to get that increased because we have seen
some swapping going on)
1 Intel 2.4 GHz Xeon processor
Mount options: rw,fg,hard,nointr,retrans=2,tcp,vers=3,timeo=600
We are using NFS over TCP by the recommendation of NetApp and because we
saw data corruption when we were using NFS over UDP. I am looking into
some of the mount options for Linux; one document says to turn noac off,
another says to turn it on. I haven't seen any reference to a
forcedirectio option, and I know that asynch I/O is not supported in NFS
for Linux (yet?).
If you have any other questions, let me know and I'll do my best to
answer them. Thanks to everyone who has responded so far!
Geoff
Haynes, Tom wrote:
>Geoff,
>
>You should have mentioned what type of filer and what version of
>OnTap you were running.
>
>Thanks,
>Tom
>
>
>
>>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(a)dalsemi.com
>>