Release Notes

Conclusion
24 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
4 Conclusion
SC Series arrays provide well-balanced storage solutions that benefit large data warehouses by reducing the
total cost without sacrificing the performance. Thin provisioning, continuous self-optimization, and data
reduction work seamlessly together to provide the most cost-efficient solution. Performance is delivered
where it is needed through auto-tiering and multi-RAID levels. When the data warehouse grows in the future,
the array can scale easily by adding drives at any time. Data is automatically rebalanced across all available
drives.
In summary, when deploying an Oracle data warehouse on SC Series storage, use the recommendations
outlined in this document for improved manageability and performance:
• Configure I/O for bandwidth and not just capacity.
• SC Series volumes for ASM should follow the Oracle recommendation on LUN sizing.
• Disable write cache on SC Series volumes that write to the SSD tier.
• Select storage profiles that benefit different data warehouse data types.
• Enable data reduction to further reduce space consumption.
• Use snapshots to create space-efficient copies of a data warehouse and improve RPO and RTO.
• Use multipath software.
• Use Oracle ASM and Oracle managed files.
• Use ASM external redundancy, unless business needs require normal or high redundancy.
• Make sure ASM disk groups contain multiple disks to sustain striping far and wide and to reduce
Linux kernel contention accessing and queuing for the same disk.
• Perform due diligence on I/O system tests before database implementation.
• Assign all volumes used by a specific database to the same consistent snapshot profile.