Oracle/HP Best Practices Guide for HP IO Accelerators

Contents 3
Contents
Overview ..................................................................................................................................... 5
Introduction ................................................................................................................................................. 5
Single-instance and RAC overview ................................................................................................................. 5
Using IO Accelerators with Oracle ................................................................................................................. 5
Setting up filesystems .......................................................................................................................... 6
Using ASM ........................................................................................................................................ 6
Redundancy architectures .............................................................................................................. 7
Redundancy best practices ............................................................................................................................ 7
Filesystem hosted data files ........................................................................................................................... 7
ASM Mirroring ............................................................................................................................................ 7
External redundancy (striping/RAID 0) ................................................................................................. 7
Normal redundancy (mirroring/RAID 1) ............................................................................................... 7
High redundancy (mirroring/RAID 10+1) ............................................................................................. 8
ASM mirroring with a read-preferred device ......................................................................................... 9
Using data guard ......................................................................................................................................... 9
Data Guard replication types ............................................................................................................ 10
Data Guard recommended reading ................................................................................................... 11
Data Guard recommended tunings .................................................................................................... 11
Generic performance tuning......................................................................................................... 12
Write performance and steady state............................................................................................................. 12
Separating data types ................................................................................................................................ 12
Discovering your application I/O profile and selecting an architecture ............................................. 13
Using Oracle tools ..................................................................................................................................... 13
Oracle Enterprise Manager ............................................................................................................... 13
Single-instance performance architectures ...................................................................................... 16
Hosting all data areas on the IO Accelerator ................................................................................................ 16
Hosting temp space on the IO Accelerator .................................................................................................... 16
Example A: Migrating temp tablespace to an IO Accelerator on a filesystem.......................................... 16
Example B: Migrating temp tablespace to an ASM disk group backed by IO Accelerators ...................... 17
Hosting redo logs on the IO Accelerator ....................................................................................................... 18
Example C: Migrating redo logs to an IO Accelerator on a local filesystem ............................................ 18
Example D: Migrating redo logs to an IO Accelerator configured with ASM .......................................... 20
Using the IO Accelerator with flash cache ..................................................................................................... 22
Prerequisites .................................................................................................................................... 22
Assessing flash cache performance improvements ............................................................................... 22
Setting up flash cache ....................................................................................................................... 23
Enabling flash cache ........................................................................................................................ 23
Sizing the flash cache ....................................................................................................................... 23
Tuning memory for the flash cache ..................................................................................................... 24
Using flash cache ............................................................................................................................. 24
Example: Flash cache use ................................................................................................................. 24
Oracle RAC performance architectures .......................................................................................... 26
SRP and iSER targets .................................................................................................................................. 26