Release Notes

Introduction
5 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
1 Introduction
The purpose of this document is to provide general best practices and sizing guidelines when deploying an
Oracle data warehouse on any SC Series array. The information provided in this document is built upon the
guiding principles and building blocks in the document, Dell EMC SC Series Arrays and Oracle. Therefore, it
should be thoroughly reviewed before implementing the best practices mentioned in this document. Actual
configuration and sizing of the components will vary based on individual business, application, and
infrastructure requirements. The recommendations presented in this document may not be relevant to all
environments and should be evaluated against specific business needs and adjusted accordingly.
This document is not intended to provide a step-by-step configuration or be an exact sizing guide. It also
should not be considered an exhaustive or authoritative source on any component discussed. Performance
tuning of any component within the document is also not covered. For information on SC Series arrays, see
the Dell Storage Manager Administrator’s Guide available on the Dell Support site. For detailed information on
any part of Oracle configuration, use the information provided at the My Oracle Support site. For detailed
information on best practices on SC Series storage for Oracle deployments, see the resources listed in
appendix B.
1.1 Audience
This document is intended for information technology professionals seeking to deploy a cost-effective Oracle
OLAP and DSS database environment using an SC Series array.
1.2 Prerequisites
It is assumed the reader has some knowledge of the benefits of SC Series storage and basic sizing principles
related to I/O subsystems, and understands key I/O performance metrics: IOPS, throughput, latencies, as well
as random I/O versus sequential I/O. Information pertaining to those topics are covered in the document, Dell
EMC SC Series Arrays and Oracle, and should be reviewed before reading this document.
Readers should have prior experience with or training in:
• Data warehousing concepts
• Basic server technologies
• Basic operating system technologies
• Basic sizing principles related to I/O subsystems
• Understanding key I/O performance metrics: IOPS, throughput, latencies, as well as random I/O
versus sequential I/O
• Validating I/O paths and storage designs
• Different RAID levels, Fibre Channel, iSCSI, serial-attached SCSI (SAS), and IP networking
administration
• Multipath software
• Operation, configuration, and benefits of SC Series storage
• Using and administrating Oracle Linux, Oracle RDBMS 11g or above, and Oracle Automated Storage
Management (ASM)
• Oracle standalone and RAC environments