Re: [zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Daniel Rock
Richard Elling schrieb: On Fri, 2006-05-19 at 23:09 +0200, Daniel Rock wrote: (*) maxphys = 8388608 Pedantically, because ZFS does 128kByte I/Os. Setting maxphys > 128kBytes won't make any difference. I know, but with the default maxphys value of 56kByte on x86 a 128kByte request will be s

Re: [zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Daniel Rock
Bart Smaalders schrieb: How big is the database? After all the data has been loaded, all datafiles together 2.8GB, SGA 320MB. But I don't think size matters on this problem, since you can already see during the catalog creation phase that UFS is 2x faster. Since oracle writes in small blo

Re: [zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Bart Smaalders
Daniel Rock wrote: Hi, I'm preparing a personal TPC-H benchmark. The goal is not to measure or optimize the database performance, but to compare ZFS to UFS in similar configurations. At the moment I'm preparing the tests at home. The test setup is as follows: . Solaris snv_37 . 2 x AMD Opteron

[zfs-discuss] Oracle on ZFS vs. UFS

2006-05-19 Thread Daniel Rock
Hi, I'm preparing a personal TPC-H benchmark. The goal is not to measure or optimize the database performance, but to compare ZFS to UFS in similar configurations. At the moment I'm preparing the tests at home. The test setup is as follows: . Solaris snv_37 . 2 x AMD Opteron 252 . 4 GB RAM . 2 x