I finally got around to running a 'benchmark' using the AOL clickstream data (2GB of text files and approximately 36 million rows). Here are the Oracle settings during the test.
- Same Oracle settings for all tests - All disks in question are 32GB EMC hypers - I had the standard Oracle tablespaces on one ASM group consisting of 1disk - I created a tablespace using ASM on 10 disks - I created a tablespace using ZFS on 10 disks - I created a tablespace using ZFS with compression on 10 disks Test 1 (loading to ASM) I loaded the text file into Oracle using external table feature. Time 1m20s, system loads were in the 1-1.35 range. Test 2 (loading to ZFS) I loaded the text file into Oracle using external table feature. Time 1m16s, system loads were in the 1.13 range. Test 3 (loading from ASM to ASM) I loaded a new table from the just loaded Oracle table. Time 1m21s, system loads were in the 1-1.3 range. Test 4 (loading from ZFS to ZFS) I loaded a new table from the just loaded Oracle table. Time 1m20s, system loads were in the 1-1.3 range Test 5 (loading from ZFS to ZFS compress=ON) I loaded a new table from the just loaded Oracle table. Time 1m18s, system loads were in the 1-1.45 range, saw a compression in the 3.5-4x range. Throughout the tests I had other stuff running on the machine as well (1 additional database and 10g GridControl Repository). [b]All the tests yielded same results in my opinion.[/b] We'll probably go with Oracle ASM because of its integration with other Oracle products/features. I'm not comfortable with ZFS enough to bet on it yet (I've only played with it for less than 2 months) while ASM has been around for 3 years. The other contributing factor is ASMs ability to rebalance the data when disks are added/removed. ZFS at this time doesn't give a facility to remove drives when I'm not using mirrors (my problem is that all our disks are provisioned from EMC that are already protected), ASM does. While performing these tests I came across another (severe?) problem with ZFS that I'll post as a separate entry. -Anantha- This message posted from opensolaris.org _______________________________________________ opensolaris-discuss mailing list [email protected]
