Using ZFS for Oracle can be configured to deliver very good performance.
Depending on what your priorities are in terms of critical metrics, keep
in mind
that the most performant solution is to use Oracle ASM on raw disk devices.
That is not intended to imply anything negative about ZFS or UFS. The simple
fact is that when you but your Oracle datafiles on any file system,
there's a much
longer code path involved in reading and writing files, along with the
file systems
use of memory that needs to be considered. ZFS offers enterprise-class
features
(the admin model, snapshots, etc) that make it a great choice to deploy in
production, but, from a pure performance point-of-view, it's not going to be
the absolute fastest. Configured correctly, it can meet or exceed
performance
requirements.
For Oracle, you need to;
- Make sure you're the latest Solaris 10 update release (update 8).
- For the datafiles, set the recordsize to align with the db_block_size (8k)
- Put the redo logs on a seperate zpool, with the default 128k recordsize
- Disable ZFS data caching (primarycache=metadata). Let Oracle cache the
data
in the SGA.
- Watch your space in your zpools - don't run them at 90% full.
Read the link Richard sent for some additional information.
Thanks,
/jim
Tony MacDoodle wrote:
Was wondering if anyone has had any performance issues with Oracle
running on ZFS as compared to UFS?
Thanks
------------------------------------------------------------------------
_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
_______________________________________________
zfs-discuss mailing list
zfs-discuss@opensolaris.org
http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
