Oracle on zfs
Hello!
We have Solaris 10 box with latest patches connected to Storedge 6130 by FC.
Storedge disks configured as RAID5
Our Oracle 10g (10.2.0.4) DB performance is terrible.
Write speed reported by "zpool iostat" about 5 MB/s and "iostat" showing 100% load for data pool.
Redo logs and data files placed on different pools. Recordsize for log - 128k, for data files 8k.
I have no idea what else i can tune. There are guides for tuning zfs for oracle (best practices guide and evil tuning guide) but nothing for tuning oracle for zfs.
I'm also worried about fact that simple
dd if=/dev/zero of=/zpool1 bs=8192k count=10240
gives 40MB/s in zpool iostat
Maybe Oracle settings are wrong?
Current settings are:
filesystemio_options=asynch
db_writer_processes=2
db_file_multiblock_read_count=8
Does ZFS support DirectIO and/or asynchronous writes like UFS?
Please help.
Thanks in advance!
(and sorry for my English)