Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle / NFS performance test

Dieter Degrendele_2
Occasional Visitor

Oracle / NFS performance test

Hi,

I would like to do a performance test to see where performs better, a oracle with DB files on a directly attached storage or with DB files on a NAS (using NFS).

Does somebody know where to find a kind of howto document that explains what and how to do a good performance test?

Thank you
11 REPLIES
A. Clay Stephenson
Acclaimed Contributor

Re: Oracle / NFS performance test

Why even bother to add Oracle to the test? The database is just noise to the experiment.
I would simply do a test writing to a local file and then to an NFS file.

timex dd if=/dev/zero bs=64k count=10000 of=/xxx/local/myfile

timex dd if=/dev/zero bs=64k count=10000 of=/xxx/remote/myfile

Unless you have incredibly slow local disks and incredibly fast network/fileserver, you are going to find that local disks win hands down.
If it ain't broke, I can fix that.
Steven E. Protter
Exalted Contributor

Re: Oracle / NFS performance test

Oracle totally does not support running its database on NFS.

That being said, its possible.

Advice:

1) if possible use vlan/subnetting to make sure the collision domain between the nfs server and clients is very small. small means less machines have access. A common problem that kills nfs access is congestion from windows workstations and such. Avoid it.

2) Use Gigabit Networking and switches to speed the data transfer and give oracle a chance. What was impossibly slow at 100 BaseT speeds becomes possible at Gigabit speeds.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
TwoProc
Honored Contributor

Re: Oracle / NFS performance test

I did it years and years ago to stand up a temporary test system. I wouldn't consider it for a production database doing any real work. If the purpose of the test is to tell which is faster - the direct I/O one is . Not much argument there. Question: do you *have* to use NFS on a NAS drive? I don't have any drives of that type to confirm, but I wasn't under the impression that it was necessary. OK, but if you're going to do it anyway, make sure to increase the db_buffer_cache to as big a number as you can handle to reduce the amount of I/O on the NFS drives. Like others mentioned - Oracle does not support this, and if you ever have problems, you're not going to get backing on it.
We are the people our parents warned us about --Jimmy Buffett
Leif Halvarsson_2
Honored Contributor

Re: Oracle / NFS performance test

Hi,
Don't know which NAS server you use but, this link may be of interest:

http://www.netapp.com/partners/oracle/
Yogeeraj_1
Honored Contributor

Re: Oracle / NFS performance test

hi,

Also, past references will tell you that you cannot run oracle on NAS, this might not be really totally true TODAY!

this document says NO: http://www.mti.com/white_papers/WP20004.PDF

I would only go for NAS that are certified NAS that are certified vendors.

For testing again, you can do it using Oracle tools like Statspack and many others.

regards
yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Dieter Degrendele_2
Occasional Visitor

Re: Oracle / NFS performance test

Thank you for your responses.
Indeed we are thinking about using a netapp NAS device. We heared that they claim that putting the db files on their NAS could increase performance with factor 2 (compared to gigabit FC). Just testing with dd is not sufficient I guess...

At the other hand, I am quite sure that DB files on NFS is supported by Oracle, because they are doing it themselves.

What I meant with my thread is that I would like to know with which parameter we should play (e.g. db_buffer_cache, packet size (on network), ....) and if there is a document that explains what to test and why.

Thanks,
Dieter Degrendele
Jean-Luc Oudart
Honored Contributor

Re: Oracle / NFS performance test

Hi,

like the others I would not recommend DB files (for any kind of database) on NFS based system.

Anyway, if you want more information on NFS performance, check this link :
http://h21007.www2.hp.com/dspp/files/unprotected/devresource/Docs/Presentations/NFSperf.pdf

Regards
Jean-Luc
fiat lux
harry d brown jr
Honored Contributor

Re: Oracle / NFS performance test

Can you point us to the documentation that CLAIMS this statement:

""""We heared that they claim that putting the db files on their NAS could increase performance with factor 2 (compared to gigabit FC). """"

??

The SECURITY risks alone are not worth it!

live free or die
harry d brown jr
Live Free or Die
Fred Ruffet
Honored Contributor

Re: Oracle / NFS performance test

I wouldn't go for NFS. I will also like to see a doc saying a NFS can be that fast...

In a recent doc, I found that Oracle supports NFS for certified Storage Partners. But in the same document, they say : "The main problem with NFS is that the protocol is not reliable"...

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Mathew Walker
Occasional Visitor

Re: Oracle / NFS performance test

NetApp has quite a few articles about NAS & Oracle.

Try:
http://www.netapp.com/tech_library/ftp/3322.pdf

Bill Hassell
Honored Contributor

Re: Oracle / NFS performance test

NFS is simply not reliable enough for a database UNLESS the network is dedicated. Letting PCs and other junk on the NFS network is a recipe to total meltdown. And as mentioned, NFS on 100Mbit is *way* slower than the slowest SCSI disks. Before you risk production data over NFS, get a copy of Dave Olker's book on NFS for HP-UX. Note that for optimum performance, you may need to change parameters in the NAS device--which might not be possible.


Bill Hassell, sysadmin