ZFS + Database Performance Considerations

  • db_block_size = recordsize (For table data and index components, create a file
  • system with an 8 KB record size.)
  • primarycache and secondarycache needs to enabled.
  • utilization under <90%
  • runs on latest solaris release.
  • Create a storage pool for data files for tables, index, undo and temp data
  • mirrored storage pool to provide a higher level of data redundancy
  • set ssd:ssd_max_throttle=20
  • set zfs:zfs_vdev_max_pending=20
  • number of LUNs * ZFS_VDEV_MAX_PENDIN
  • Allocate sufficient memory and swap resources

More info

Advertisements

Author: jee

Oracle Engineered Guy work for Oracle Corp. Techno-addict for Exadata, SuperCluster, ODA, RAC, ASM, HA.Fusion Music Enthusiast,Son,Husband,Father, Information-news- Freak, Optimist, Humanist. Interests : Technology, Innovation, Sharing interesting content. Views expressed on this account are my own and don't necessarily reflect the views of Oracle & its affiliates.