Release Notes

Optimize an SC Series array for an Oracle data warehouse
23 Optimizing Dell EMC SC Series Storage for Oracle OLAP Processing | 2009-M-BP-O
Oracle Automatic Workload Repository (AWR) can be used to help estimate how much storage is required for
snapshots. It provides detailed usage information on redo logs, archived logs, temporary space, and data
files. Administrators should be able to deduce the data-change rate from the AWR reports. Reports should
cover different time periods to coincide with the time the snapshots are intended to be taken, and the
information used as the basis of the calculation.
Dell EMC is well equipped to help customers analyze both storage and performance requirements based on
many of these inputs.
3.6.4 Test the I/O system before implementation
I/O performance should be validated and tested before putting the environment into full production mode.
Tools such as Oracle ORION, vdbench, and FIO provide a comprehensive set of features to exercise and
measure the storage. ORION has an advantage over others because it is explicitly designed to simulate
Oracle database I/O workloads using the same I/O software stack as Oracle. It also provides a data
warehouse simulation mode which simplifies the setup and execution of the test. ORION has been bundled
with the Oracle database software and can be found in $ORACLE_HOME/bin directory. See appendix B.1 for
references to these performance tools. For more information on how to configure and run ORION, see
chapter, Calibration with the Oracle Orion Calibration Tool, in Oracle Performance Guide.