Deploying Oracle Databases Using NFS on Sun Storage 7000 Unified Storage System

Sridhar Ranganathan and Jeffrey Wright, May 2009 (Updated May 12)

Introduction

This quick start guide shows how to deploy Oracle Database using the NFS protocol with the Sun Storage 7000 Unified Storage System.

The Sun Storage 7000 Unified Storage System supports NFS v3, NFS v4, iSCSI, and CIFS protocols and comes with a comprehensive set of data service features that can provide unlimited snapshots, clones, and remote replication. The release used in this scenario was 2008.Q4.  For more information, see this white paper: Configuring Sun Storage 7000 Unified Storage Systems for Oracle Databases.

Contents

• Executive Overview
• Introduction
  • Overview of the Sun Storage 7000 Unified Storage Systems
  • Ideal Application Profiles
• Configuring Unified Storage Systems
• Basic Performance Measurements
  • Test Environment
  • 128kB Skip-Sequential Read
  • 128kB Skip-Sequential Write
  • 8kB Random Read
  • 8kB 75 Percent Read/25 Percent Write/100 Percent Miss
• Estimating System Performance with Cache Hit and Miss I/O
• Data Access Characteristics Using Oracle Database Workloads
  • Environment for Oracle Database Testing
  • Oracle Database Tests
  • Oracle Database Testing Results
• Implementation Guidelines
  • Choosing a Unified Storage System Model
  • Write-Optimized Flash Devices
  • Read-Optimized Flash Devices
  • Access Protocol
  • Project and Share Configuration for Snapshot and Replication
  • General Database Layout.
  • Performance-Optimized Sun Storage 7000 System Layouts for Oracle Databases
  • Detailed DTrace Analytics
• Conclusion
• About the Authors
• References

For More Information

Here are some additional resources:

• Oracle Technology Network
• Sun Storage 7000 Unified Storage System web site
• Sun BluePrints papers (registration required), such as Configuring Sun Storage 7000 Systems for Oracle Databases
• Sun download site
• Sun training courses at http://www.sun.com/training/, for example, Sun Storage 7000 Unified Storage System Administration (NWS-6425)
• Sun forums such as:
  • Sun forums
  • BigAdmin Discussions collection
• Sun product documentation at http://docs.sun.com, such as:
  • Sun Storage 7000 Unified Storage System documentation
• Sun Documentation Center
• BigAdmin wiki:
• • Storage Tech Tips page
  • Databases page
• Resources on BigAdmin, such as:
  • Database resource collection (includes community content)
  • Storage resource collection (includes community content)
• Support:
  • Sun resources:
    • Register your Sun gear
    • Services
    • SunSolve Online
  • Community system administration experts
• Events of interest to users of Sun products:
  • Worldwide Developer Events and Sun Tech Days
  • Current Events

Unless otherwise licensed, code in all technical manuals herein (including articles, FAQs, samples) is provided under this License.