Words About Oracle Direct NFS On Sun Storage 7410 And Chip Multithreading Technology (CMT) For Oracle Database 11g Release 2.

My old friend Glenn Fawcett and I have been teaming up on Sun Oracle Database Machine DW/BI/OLTP performance engineering work, but last week Glenn told me he had an opportunity to put a late model Sun T5240 CMT system through the OLTP wringer. After consulting with me about workload options I set Glenn up with one of my favorite Pro*C Order Entry OLTP workload kits (no, it’s not TPC-C). We thought it would be quite interesting to compare a T5240 to a Sun Fire 4100 (the compute nodes in a Sun Oracle Database Machine) in a head to head test. Nothing official, just pure science. That work is still underway.

For new reader’s sake, I’d like to point out an old blog entry I made (circa 2006) after seeing a lot of TechMarketingBafoonery™ slung about by Sun competitors suggesting the CoolThreads SPARC architecture is unfit for Oracle because it is has only a single floating point engine per socket. That blog entry can be found here:

Marketing Efforts Prove Sun Fire T2000 Is Not Fit For Oracle Database Processing

What Storage To Test With?
The storage option that became available to Glenn was a Sun 7000 NAS device (a.k.a., project Fishworks). I recommended Glenn set up Direct NFS in order to efficiently drive the storage. I see that Glenn has posted some Solaris Direct NFS related information as a result of his efforts over the last couple of days. I recommend Glenn’s post about Solaris Direct NFS Configuration and Verification and Glenn’s new fledgling blog in general.

That Oracle Over NFS Stuff Is So Avant Garde
I’d like to point out, for new blog readers, that I have been a long-standing advocate of Oracle over NFS as a storage solution. The following posts are a good place to start if you want some food for thought on why Oracle Direct NFS is a good storage protocol and Oracle over NFS is a good storage architecture in general:

And, CFS, NFS Topics here.

5 Responses to “Words About Oracle Direct NFS On Sun Storage 7410 And Chip Multithreading Technology (CMT) For Oracle Database 11g Release 2.”


  1. 1 Robert Klemme November 20, 2009 at 10:33 am

    Kevin, I believe the mere fact that your “NFS advocate list” is so long (10+ entries) is a strong hint that you should probably distill the NFS advocacy into a single article. :-)

    Kind regards

    PS: And please keep us updated about Glenn’s head to head benchmark results. Can’t wait to see the results. :-)

    • 2 kevinclosson November 20, 2009 at 3:17 pm

      “And please keep us updated about Glenn’s head to head benchmark results. Can’t wait to see the results.”

      …I’ve been analyzing the results thus far. I have to admit that I’m actually quite surprised at how well that little CMT box is holding up in the shadow of the mighty Nehalem EP on a per-socket basis. I’ll probably have to give significant thought to what is politically expedient to blog about once I’m finished with my analysis.

  2. 3 oraclue May 5, 2010 at 7:53 pm

    Kevin,

    I am reading Oracle Documentation 11.1 ( Oracle® Database Storage Administrator’s Guide – 2 Preparing Storage for ASM )

    NFS files—NFS files are suitable for testing, but are not a recommended configuration for production environments. Using NFS files with ASM duplicates ASM functionality.

    but

    Oracle® Database Storage Administrator’s Guide
    11g Release 2 (11.2) 2 Considerations for Oracle ASM Storage

    An Oracle ASM disk group can be created from NFS files, including Oracle Direct NFS (dNFS), as well as whole disks, partitions, and LUNs. The NFS files that are provisioned to a disk group may be from multiple NFS servers to provide better load balancing and flexible capacity planning.

    Your thoughts ( resources if any ) about using ASM with Direct NFS ?

    Thanks in advance,

    Miladin

    • 4 kevinclosson May 6, 2010 at 5:31 pm

      In my opinion the best value add ASM can have in an NFS environment is to set up normal redundancy between filers. If you don’t think your filers will ever fail, then you can get cross-filer striping by using ASM with normal NFS files and external redundancy. Either model is supported. Saying “NFS files with ASM duplicats ASM functionality” insinuates that all NFS files have the same RAID characteristic underpinnings that ASM offers and that is simply not the case. True, most filers implement mirroring and striping underneath the file system that is being exported, but it is not safe to state that matter-of-factly.


  1. 1 Direct NFS in Solaris with Oracle 11g: Benchmarks « UNIX Administratosphere Trackback on December 15, 2009 at 10:01 am

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




EMC Employee Disclaimer

The opinions and interests expressed on EMC employee blogs are the employees' own and do not necessarily represent EMC's positions, strategies or views. EMC makes no representation or warranties about employee blogs or the accuracy or reliability of such blogs. When you access employee blogs, even though they may contain the EMC logo and content regarding EMC products and services, employee blogs are independent of EMC and EMC does not control their content or operation. In addition, a link to a blog does not mean that EMC endorses that blog or has responsibility for its content or use.

This disclaimer was put into place on March 23, 2011.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 2,058 other followers

Oracle ACE Program Status

Click It

website metrics

Fond Memories

Copyright

All content is © Kevin Closson and "Kevin Closson's Blog: Platforms, Databases, and Storage", 2006-2013. Unauthorized use and/or duplication of this material without express and written permission from this blog’s author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Kevin Closson and Kevin Closson's Blog: Platforms, Databases, and Storage with appropriate and specific direction to the original content.

Follow

Get every new post delivered to your Inbox.

Join 2,058 other followers

%d bloggers like this: