Dell Acceleration Appliances for Databases Manuel d'utilisateur télécharger pdf (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.

1 2 ... 70 71 72 73 74 75 76 77 78 79 80 ... 88 89

Pas de commentaire

Dell Acceleration Appliances for Databases Manuel d'utilisateur Page 75