- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle / NFS performance test
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 02:57 AM
тАО03-22-2005 02:57 AM
Oracle / NFS performance test
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 03:04 AM
тАО03-22-2005 03:04 AM
Re: Oracle / NFS performance test
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 04:03 AM
тАО03-22-2005 04:03 AM
Re: Oracle / NFS performance test
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 04:36 AM
тАО03-22-2005 04:36 AM
Re: Oracle / NFS performance test
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 07:03 AM
тАО03-22-2005 07:03 AM
Re: Oracle / NFS performance test
Don't know which NAS server you use but, this link may be of interest:
http://www.netapp.com/partners/oracle/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 04:07 PM
тАО03-22-2005 04:07 PM
Re: Oracle / NFS performance test
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 08:32 PM
тАО03-22-2005 08:32 PM
Re: Oracle / NFS performance test
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 11:19 PM
тАО03-22-2005 11:19 PM
Re: Oracle / NFS performance test
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2005 11:23 PM
тАО03-22-2005 11:23 PM
Re: Oracle / NFS performance test
""""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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-23-2005 02:23 AM
тАО03-23-2005 02:23 AM
Re: Oracle / NFS performance test
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.)