I thought oracle over NFS wanted 'directio' as a mount option?
On Wed, Mar 28, 2012 at 4:42 PM, Fletcher Cocquyt fcocquyt@stanford.eduwrote:
Hi, I'm not seeing write performance issues on the OS (throughput tests on the command line are > 100Mb/sec)
But Oracle is complaining about long commit times for the Netapp NFS mount with the following options:
rw,noatime,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768 (matches what I see in Oracle and Netapp docs)
I'm working with the DBA to see if the Oracle tuning is optimal, but thought I'd poll this list for any nuggets of tuning Oracle on Netapp NFS
And the disk busy on this aggregate is only 10% - and the CPU reads 40-50%
thanks!
Fletcher
Toasters mailing list Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters