I would second this – using DirectNFS we found greatly increased performance over native NFS.  You can also use the multipathing in DirectNFS to see some additional performance benefits.

 

From: toasters-bounces@teaparty.net [mailto:toasters-bounces@teaparty.net] On Behalf Of Dan Finn
Sent: Wednesday, March 28, 2012 8:19 PM
To: Jeff Mohler; Roy Choudhury, Bikash
Cc: Mailing Lists
Subject: Re: Oracle (RHEL 5.7) on NFS (Ontap 8.1RC2) - complains of write

 

I don't remember what it's called but there's also a way that you can have Oracle manage the NFS mounts directly from inside the app.  We did this at my last place and there was a performance improvement.  I think it's a newer feature that is part of 10G or 11G, sorry, don't know the Oracle stuff that well.

 

That being said, it seems like DBAs are always complaining about performance but I'm never able to see it when testing from my end.

 


From: Jeff Mohler <speedtoys.racing@gmail.com>
To: "Roy Choudhury, Bikash" <Bikash.Choudhury@netapp.com>
Cc: Mailing Lists <toasters@teaparty.net>
Sent: Wednesday, March 28, 2012 6:04 PM
Subject: Re: Oracle (RHEL 5.7) on NFS (Ontap 8.1RC2) - complains of write

 

*nod*

Dont work much in the DB area..was not sure.   :)

On Wed, Mar 28, 2012 at 4:57 PM, Roy Choudhury, Bikash <Bikash.Choudhury@netapp.com> wrote:

There is no "directio mount option in Linux.

Bikash


On Mar 28, 2012, at 4:54 PM, "Jeff Mohler" <speedtoys.racing@gmail.com> wrote:

I thought oracle over NFS wanted 'directio' as a mount option?


On Wed, Mar 28, 2012 at 4:42 PM, Fletcher Cocquyt <fcocquyt@stanford.edu> wrote:

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




--
---
Gustatus Similis Pullus

_______________________________________________
Toasters mailing list
Toasters@teaparty.net
http://www.teaparty.net/mailman/listinfo/toasters




--
---
Gustatus Similis Pullus


_______________________________________________
Toasters mailing list
Toasters@teaparty.net
http://www.teaparty.net/mailman/listinfo/toasters

THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.