My Oracle Support Banner

Oracle ZFS Storage Appliance: Best Practices when using the ZFS-SA for Databases (Doc ID 2079993.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Sun ZFS Storage 7420 - Version All Versions to All Versions [Release All Releases]
Oracle ZFS Storage ZS4-4 - Version All Versions to All Versions [Release All Releases]
Oracle ZFS Storage ZS3-BA - Version All Versions to All Versions [Release All Releases]
Oracle ZFS Storage ZS3-2 - Version All Versions to All Versions [Release All Releases]
Oracle ZFS Storage ZS3-4 - Version All Versions to All Versions [Release All Releases]
7000 Appliance OS (Fishworks)

Symptoms

The ZFS appliance is suited for any kind of workloads such as video streaming, backups, Virtual Machines or databases. This document describes the rules to observe to get the best possible performance when running databases on top of shares or volumes exported by the ZFS appliance.

Changes

Some performance issues can be reported on databases using shares or volumes exported by the ZFS appliance. This can happen some weeks after the initial usage, just because the load is getting higher.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Pool layout
 Datasets recordsize and logbias settings
 Possible miss-alignments
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.