There is no "directio mount option in Linux.

Bikash

On Mar 28, 2012, at 4:54 PM, "Jeff Mohler" <speedtoys.racing@gmail.commailto: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.edumailto: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.netmailto:Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters

-- --- Gustatus Similis Pullus _______________________________________________ Toasters mailing list Toasters@teaparty.netmailto:Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters

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

Easy to set up too. The newer versions (of Oracle) have a script. If you have only a single network out of the db server, you simply replace one of the oracle libraries with the directnfs library (it is part of the script).

If you have more than one network connection from your server to your NetApp, you still would need to configure a simple file defining source/dest paths and mounts.

Very easy. Each oracle process needing to access files gets its own port to communicate on and oracle handles all the appropriate file locking as needed.

Linux, Solaris, AIX, Windows(using DirectNFS) are all supposed to perform about the same.

--tmac          Tim McCarthy      Principal Consultant

RedHat Certified Engineer    804006984323821 (RHEL4)    805007643429572 (RHEL5)

On Wed, Mar 28, 2012 at 8:22 PM, Jeff Mohler speedtoys.racing@gmail.com wrote:

Direct nfs?

ya..its fast.   :)

On Wed, Mar 28, 2012 at 5:19 PM, Dan Finn dan_j_finn@yahoo.com wrote:

...

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

--

Gustatus Similis Pullus

---

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

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=3276 8 (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

Yup, that was it.

________________________________ From: "Zito, Matthew" Matt_Zito@bmc.com To: Dan Finn dan_j_finn@yahoo.com; Jeff Mohler speedtoys.racing@gmail.com; "Roy Choudhury, Bikash" Bikash.Choudhury@netapp.com Cc: Mailing Lists toasters@teaparty.net Sent: Wednesday, March 28, 2012 6:48 PM Subject: RE: Oracle (RHEL 5.7) on NFS (Ontap 8.1RC2) - complains of write

DirectNFS - if you're using 11gR1 or newer, you should definitely use that.

Matt ________________________________________ From: toasters-bounces@teaparty.net [toasters-bounces@teaparty.net] On Behalf Of Dan Finn [dan_j_finn@yahoo.com] 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.commailto: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.commailto: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.edumailto: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.netmailto:Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters

-- --- Gustatus Similis Pullus _______________________________________________ Toasters mailing list Toasters@teaparty.netmailto:Toasters@teaparty.net http://www.teaparty.net/mailman/listinfo/toasters

-- --- Gustatus Similis Pullus

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