1. Managing ZFS File Systems in Oracle Solaris 11.4
  2. Recommended Oracle Solaris ZFS Practices
  3. Recommended File System Practices
  4. File System Creation Practices for an Oracle Database

File System Creation Practices for an Oracle Database

Consider the following file system practices when creating an Oracle database.

  • Match the ZFS recordsize property to the Oracle db_block_size.

  • Create database table and index file systems in main database pool, using an 8 KB recordsize and the default primarycache value.

  • Create temp data and undo table space file systems in the main database pool, using default recordsize and primarycache values.

  • Create archive log file system in the archive pool, enabling compression and default recordsize value and primarycache set to metadata.