Solaris ZFS Configuration Settings for Oracle Database

Products

• CA eHealth

Issue/Introduction

Description:

PRD00049798
eHealth 6.2

On a Solaris ZFS, a customer with a large database observed that there were errors in the Oracle alert log and that the eHealth poller was hanging. The customer was running on a Solaris ZFS that was not properly configured for Oracle.

Solution:

This article provides guidelines for configuring Oracle Solaris ZFS for the eHealth Oracle database.

1. Set the ZFS record size to the Oracle database block size for the file system that contains the Oracle data files. The default record size is probably 128 KB, and it must be changed to 8 KB.
   
   
2. Reduce the ZFS Adaptive Replacement Cache (ARC) size from 8 GB to 2 GB. This setting is changed by editing /etc/system and adding or editing zfs:zfs_arc_max. (This reduction will not degrade performance because Oracle has its own buffer cache.)

For additional details, see the "Configuring?ZFS for an Oracle Database"?and "Configuring Oracle Solaris ZFS for an Oracle Database" white papers posted at:http://www.oracle.com/technetwork/server-storage/solaris10/config-solaris-zfs-wp-167894.pdfand
http://www.oracle.com/technetwork/server-storage/solaris10/documentation/wp-oraclezfsconfig-0510-ds-ac2-163550.pdf.

Environment

Release: LHBASC99000-6.2-eHealth-Live Health Upgrade Elements
Component: