Release Notes

Optimize an SC Series array for an Oracle data warehouse
16 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
Volume attributes in DSM
3.4.3 Initial loading of historical data
If a large amount of data will be transferred into the data warehouse initially, it might not be desirable to
consume all tier 1 storage for the initial load. A common practice is to direct data during ingestion to the
lowest tier where capacity is abundant. In DSM, select the Low Priority storage profile on each volume for
the duration of the ingestion. After the initial loading is complete, change the profile to Recommended. This
allows Data Progression to start relocating the data to different RAID levels and tiers based on actual I/O
patterns in the subsequent progression cycles.
3.4.4 Data reduction
In addition to thin-provisioning and multi-RAID configuration, the SC Series deduplication and compression
further reduce the space consumption on the storage array. When deduplication is enabled on a volume, it
automatically enables compression as well, though compression can be enabled without deduplication. The
space savings is largely dependent on the data stored in a data warehouse. Since the features can be turned
on or off at any time, administrators are encouraged to enable the features and assess their performance and