Release Notes

10 Migrating an Oracle Database to Dell EMC SC Series Storage | CML1001
3.2.1.2 Transactions
These are measurements in terms of database transactions and latency. In most cases, the application
vendors would have some built-in facilities that allow capturing such information. For an Oracle database, the
mostly used utilities are statspack and AWR. AWR is preferred to the older statspack but either one can
provide abundant performance statistics of a database.
3.2.2 Capacity
The advanced features of SC Series such as thin provisioning, auto-tiering, multi-RAID levels, data reduction
features, and snapshot capability make the best and most efficient use of storage space possible. To figure
out the capacity needed to support the applications and databases being migrated to the SC Series, consider
the following factors that have direct effects on the storage consumption. Also, storage capacity can be
dynamically added or removed from the SC Series without affecting the applications. Thus, customers only
invest in what they need and still maintain the flexibility to meet any future growth.
• All flash, all HDDs, or a hybrid system
• RAID types
• Snapshot frequency and retention policy
• Use of deduplication and compression
• Number of database environments (full size plus thin clone)
• Data growth rate
• Data change rate
• Oracle ASM redundancy level
• Amount of archive logs to keep
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. DBAs should be able to deduce the data-change rate from the AWR reports. Reports should be
generated from 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.3 Configure SC Series volumes for the database
This section shows some of the features unique to the SC Series that might influence how the database
storage layer is configured. A detailed discussion of configuring Oracle RDBMS on an SC Series array can be
found in the document, Dell EMC SC Series Arrays and Oracle. Many of the features can be enabled through
setting the various volume attributes at any time during or after the initial creation.
3.3.1 Database volumes attributes
The following SC Series volume attributes can be defined and modified in DSM:
Number of volumes: To take advantage of both controllers in an SC Series array, it is recommended to have
at least two volumes configured for a database. Keep the total number of volumes within the limit of a