On Sat, Nov 22, 2008 at 11:41 AM, Chris Greer <[EMAIL PROTECTED]> wrote: > vxvm with vxfs we achieved 2387 IOPS
In this combination you should be using odm, which comes as part of the Storage Foundation for Oracle or Storage Foundation for Oracle RAC products. It makes the database files on vxfs behave much like they live on raw devices and tends to allow much higher transaction rate with fewer physical I/O's and less kernel (%sys) utilization. The concept is similar to but different than direct I/O. This behavior is hard, if not impossible, to test without Oracle in the mix because (AFAIK) oracle is the only thing that knows how to make use of the odm interface. > vxvm with ufs we achieved 4447 IOPS > ufs on disk devices we achieved 4540 IOPS > zfs we achieved 1232 IOPS When you say RAC, I assume you mean multi-instance (clustered) databases. None of those are cluster file systems and as such are worthless for multi-instance oracle databases which require a shared file system. On Linux, you say that you were using ocfs. Where you really using ocfs, or were the databases really in ASM? Oracle's recommendation (last I knew) was to have executables on ocfs and have databases in ASM. Have you tried ASM on Solaris? It should give you a lot of the benefits you would expect from ZFS (pooled storage, incremental backups, (I think) efficient snapshots). It will only work for oracle database files (and indexes, etc.) and should work for clustered storage as well. -- Mike Gerdts http://mgerdts.blogspot.com/ _______________________________________________ zfs-discuss mailing list zfs-discuss@opensolaris.org http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
