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.