Release Notes
Optimize an SC Series array for an Oracle data warehouse
17 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
space-saving benefits at the most convenient time. The following offers an example where data reduction
features might be suitable in a data warehouse.
Note: Do not enable SC Series data reduction on the same set of data where database/application-level data
reduction is already enabled. There might not be significant reduction savings on already reduced data.
Data reduction model based on data types
ASM disk groups
Data type
Data reduction
+DATA1DG
• Historical data
Deduplication with compression
+DATA2DG
• Customized/summarized data
None
+SYSTEMDG
• Metadata
• Redo logs
• System data
• Temp data
None
+FRADG
• Archived logs
LVM disk groups
Data type
Data reduction
vgoracle
• Oracle binaries
• Oracle logs
• Oracle data pump files
Deduplication with compression
1
1
Internal testing shows 40–50% savings on Oracle binaries, logs, and data pump files when deduplication and
compression are turned on. The actual savings will vary based on the amount of files accumulated in the file system.
Data Reduction is set in the Edit Volume dialog box in DSM (see Figure 3). Three options are available:
• Deduplication with Compression
• Compression
• None (Default)
It is recommended to enable the feature on the database volumes for a period of time long enough to go
through a typical workload cycle. The amount of space savings is reflected in DSM after Data Progression
has run. The information can be found in the following locations within DSM:
• For volume-specific data-reduction statistics, the savings are displayed under the volume Statistics
tab. See Figure 4.
• For array-wide data-reduction summary statistics, the savings are displayed under Storage Types >
Summary tab. See Figure 5.
• To see the data-reduction savings of all volumes in one place, go to Storage Types > Volumes tab.
See Figure 6.
For more information on SC Series data reduction, refer to the Dell Storage Center OS 7.0 Data Reduction
with Deduplication and Compression Solution Guide.