Release Notes

Table of contents
3 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
Table of contents
1 Introduction ................................................................................................................................................................... 5
1.1 Audience ............................................................................................................................................................. 5
1.2 Prerequisites ....................................................................................................................................................... 5
2 SC Series overview ...................................................................................................................................................... 6
3 Optimize an SC Series array for an Oracle data warehouse ....................................................................................... 8
3.1 Create a high availability SAN ............................................................................................................................ 8
3.1.1 Redundant hardware components, SC Series virtual ports, and fault domains ................................................. 8
3.1.2 Multipath I/O software ......................................................................................................................................... 8
3.2 Direct attach with front-end SAS ........................................................................................................................ 9
3.3 Storage layout for an Oracle database ............................................................................................................... 9
3.3.1 Oracle ASM ...................................................................................................................................................... 11
3.3.2 Linux LVM ......................................................................................................................................................... 12
3.4 Achieve greater storage efficiency and performance ....................................................................................... 12
3.4.1 Storage tiers and tier redundancy .................................................................................................................... 12
3.4.2 Dynamic data placement with storage profiles ................................................................................................. 13
3.4.3 Initial loading of historical data ......................................................................................................................... 16
3.4.4 Data reduction .................................................................................................................................................. 16
3.4.5 Thin provisioning compared to preallocating storage ....................................................................................... 19
3.4.6 Volume cache ................................................................................................................................................... 20
3.5 Protecting Oracle with snapshots and a consistency group ............................................................................. 20
3.6 Sizing considerations ........................................................................................................................................ 21
3.6.1 Collect and measure performance statistics .................................................................................................... 21
3.6.2 Configure I/O for bandwidth .............................................................................................................................. 22
3.6.3 Capacity planning ............................................................................................................................................. 22
3.6.4 Test the I/O system before implementation ...................................................................................................... 23
4 Conclusion .................................................................................................................................................................. 24
A Storage profiles and RAID levels ............................................................................................................................... 25
B Technical support and resources ............................................................................................................................... 27