Oracle ASM on ScaleIO Best Practices

• 1

  Overview
• 2

  Document purpose
• 3

  Scope
• 4

  Notes
• 5

  Terminology
• 6

  We value your feedback

• 1

  Overview
• 2

  Converged or hyperconverged
• 3

  Disk type selection
• 4

  Storage pool design
• 5

  Volumes and consistency groups
• 6

  Volume sizing

• 1

  Volume mapping
• 2

  Partition offset
• 3

  UDEV rules
• 4

  ASMLib
• 5

  ASM Filter Driver (12cR2)

• 1

  Overview
• 2

  Shared or database-specific ASM diskgroups
• 3

  How many ASM diskgroups?
• 4

  ASM disk sizes and counts
• 5

  Resizing existing ASM disks
• 6

  ScaleIO volumes, ASM diskgroup, and database datafile relationship
• 7

  ASM redundancy
• 8

  Allocation Unit (AU) size
• 9

  ASM extents
• 10

  ASM stripesize, coarse, and fine grained striping
• 11

  ASM maximum I/O size
• 12

  ASM diskgroup—adding and removing disks
• 13

  ASM intelligent data placement and physical disk placement
• 14

  ASM compaction and rebalance (ASM 11.1.0.7 and later)
• 15

  Summary

• 1

  Overview
• 2

  VMDKs or RDMs
• 3

  Traditional VMFS/VMDK datastores
• 4

  VMFS limits
• 5

  VMFS volumes
• 6

  Oracle RAC—Selecting VMDKs or RDMs
• 7

  VMDKs and pRDMs feature summary
• 8

  Dell EMC ScaleIO SAN features for traditional VMDKs
• 9

  Summary

• 1

  Overview
• 2

  Database/tablespace block size
• 3

  Autoextend data files
• 4

  Oracle Database parameter settings
• 5

  Flashback logs

• 1

  Database redo log configuration
• 2

  Controlfile configuration

• 1

  Conclusions

• 1

  Shell script for UDEV rules

• 1

  Overview
• 2

  ATTRIBUTE.SQL
• 3

  CLIENTS.SQL
• 4

  DISK11
• 5

  DISKGROUP
• 6

  FILE
• 7

  OPERATION11