Pool Creation Practices for an Oracle Database

Consider the following storage pool practices when creating an Oracle database.

  • Use a mirrored pool or hardware RAID for pools

  • RAID-Z pools are generally not recommended for random read workloads

  • Create a small separate pool with a separate log device for database redo logs

  • Create a small separate pool for the archive log

For more information about tuning ZFS for an Oracle database, see Tuning ZFS for Database Products in Oracle Solaris 11.4 Tunable Parameters Reference Manual.