Configuring Sun Storage 7000 Systems for Oracle Databases 
by Jeffrey T. Wright and Sridhar Ranganathan
January 2009
In planning storage solutions for Oracle database applications, Sun Storage 7000 Unified Storage Systems offer a range of performance and scalability options, and can be configured to meet specific application requirements for capacity, performance, and reliability. Because these systems offer such tremendous configuration flexibility,
storage architects face a number of decisions in designing optimal configurations to meet Oracle database storage requirements.
To help the system planner understand how to accurately match a Unified Storage System configuration to specific Oracle data access requirements, this article provides results for two sets of I/O-related tests: testing of fundamental system I/O service times and testing under a series of Oracle database workloads. This Sun BluePrints™ article reviews configuration criteria and also discusses some important implementation guidelines.
Contents
- Configuring Sun™ Storage 7000 Unified Storage Systems for ORACLE® Databases
- Overview of the Sun Storage 7000 Unified Storage Systems
- Ideal Application Profiles
- Configuring Unified Storage Systems
- Basic I/O Service Time 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
- Detailed DTrace Analytics
- Summary
- About the Authors
- References
- Ordering Sun Documents
- Accessing Sun Documentation Online
Jeff Wright works in the Application Integration Engineering (AIE) Group in Sun's Systems Organization. Jeff remains obsessed with performance topics involving Oracle and data storage technologies from product conception to final delivery. His recent focus has been on improving the timeliness and accuracy of storage solutions that Sun proposes and delivers to customers. Prior to joining Sun in 1997 through the StorageTek acquisition, Jeff worked as systems test engineer for disk storage products. His early career experiences in automotive manufacturing, software development, and experimental physics shaped his unique approach and perspectives on assessing storage performance and designing storage architectures for database systems.
Sridhar Ranganathan also works in the Application Integration Engineering Group in Sun's Systems Organization. His group's charter is to continuously improve the competitive standing of Sun open storage products for key independent software vendor (ISV) applications. Sridhar works on feature, functionality, and performance tests involving Oracle database management systems in conjunction with traditional storage and open storage technologies. Prior to joining Sun in 2000, his early career experiences were in software development and database administration in the manufacturing and banking industries.
| Rate this blueprint (Log In to vote.) | |
|---|---|
| Choices | Your Vote |
Great |
|
Good |
|
Fair |
|
Poor |
|
Sign up or Log in to add a comment or watch this page.