I have seen the best oracle performance on ZFS by
1. match the zfs record size to oracle db_block_size
2. use the default 128k record size for oracle logs.
3. If possible use a separate zpool for the oracle logs.
This is especially true if your workload has a high
write component to it.
Two other knobs help (vdev cache/stb and vq_max_pending)
but i do not recommend them right now. I believe work is
already underway to have better values out-of-the-box.
hth,
-neel
ps:If you want to know about vq_max_pending, please read
Eric Kustarz's blog @
http://blogs.sun.com/erickustarz/entry/vq_max_pending
[EMAIL PROTECTED] wrote:
On Fri, Aug 25, 2006 at 06:52:17PM +0200, Daniel Rock wrote:
[EMAIL PROTECTED] schrieb:
Hi all,
Does anybody use Oracle on ZFS in production (but not as a
background/testing database but as a front line) ?
[ ... ]
Robert and Daniel,
How did you put oracle on ZFS:
- one zpool + one filesystem
- one zpool + many filesystems
- a few zpools + one filesystem on each
- a few zpools + many filesystem on each
przemol
_______________________________________________
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
