Dell Acceleration Appliances for Databases - Manual (Page 75)

Best Practices for Oracle Database
_______________________________________________________________________
This section outlines best practices for using ION Accelerator with Oracle Database and Oracle ASM.
ORACLE DATABASE IMPLEMENTATION BEST PRACTICES
• After configuring ION Accelerator, export the ION Accelerator volumes to the Oracle
Database nodes (standalone or RAC).
• Install Oracle with the “database binary” (software-only) option.
• Run the Oracle synthetic benchmark tool Orion to measure IOPS and bandwidth on ION
volumes with various workloads (OLTP, DSS, RAID). You can also use the FIO tool to
benchmark these performance categories.
• Make sure the Orion/FIO performance stats come closer to the theoretically possible
performance of the hardware setup (HBAs on the target, initiator, and ioDrive/ioScale).
• Install Oracle Grid Infrastructure. Configure the database and run the “read only”
ioCalibration
tool to determine the IOPS, MBPS, and latency of the setup.
• Record your performance stats. These will serve as the baseline for the setup if application
performance issues are noted during workload tests.
• Configure NUMA and HugePages for Oracle.
ASM BEST PRACTICES
• ASM limits the LUN size to 2TB or less, so ION Accelerator volumes should be created no
larger than that.
• An ASM diskgroup can be created using one or multiple ION Accelerator volumes. For better
performance it’s recommended to create fewer ASM diskgroups on more ION Accelerator
volumes.
68