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
_______________________________________________
Toasters mailing list
Toasters@teaparty.nethttp://www.teaparty.net/mailman/listinfo/toasters