Tuesday, September 22, 2009

SUN Zettabyte File System (ZFS) + ORACLE

ZFS is a new kind of file system that provides simple administration, transactional semantics, end-to-end data integrity, and immense scalability. See on opensolaris. what is ZFS.

New Information Update
Configuring Oracle Solaris ZFS and your Oracle Database – A white Paper which provides planning information and step-by-step instructions for configuring and maintaining Oracle Solaris ZFS file systems for an Oracle database.

 Officially supported by Oracle: 27 April 2009 
  Oracle Database 10gR2  ( and higher patches)  
  This is for single instance ONLY. ZFS is currently not applicable to RAC and not Certified.

  Also please review the next documentation: SunNews
• Fast and easy to add disk space.
• Easy to clone a database from development → test → prod
• If you detect some strange behavior in your prod environment, make a clone and try to figure    out the issue without touching your PROD data.

Point Of Interest on Oracle level
 -  For better OLTP performance, match the ZFS recordsize to the Oracle db_block_size.
 -  Keep an eye on batch reporting during mixed batch and OLTP; a small recordsize can lead to an IOPS
     inflation during batch.
 -  Use a separate file system with the default 128K record size for Oracle logs.
 -  You can create a ZFS storage pool with separate devices for the ZFS intent log (ZIL).
 -  Consider minimizing Oracle log latency if this is the only I/O in the transaction path. With SAN storage
    arrays, Oracle log latency should be close to the latency of writing to the SAN caches and no need exists
     to partition spindle resources between data space and log space: a single pool works.
  - For Oracle over JBOD storage, it has been observed that using a segregated set of spindles (not subject
     to competing reads or writes) can help the log latency. This in turn can help some workloads, such as
     those with a high write to read ratio at the storage level. For the Oracle log pool, using some fast
     separate devices (NVRAM, battery back DRAM, 15K RPM drivces) for the intent log, appears like a
      very good idea.

On metalink 
  Doc id: 403202.1  Certification of Zeta File System (Zfs) On Solaris 10 for Oracle RDBMS
  Information Solaris ZFS_Best_Practices_Guide