ASM vs ZFS
My database version is 12.1.0.2 on solaris sparc 5.10. It's standalone server, running grid and rdbms.
I've 2 tablespaces :
1. tbsasm
Datafile is created on asm diskgroup with au=64m.
2. tbsfs
Datafile is create on zfs fs
I find querying table from tbsasm to be slower compared to querying table from tbsfs. Both tables have equal rows.
SQL> select count(*) from SYSOBJECTS_ASM ;
COUNT(*)
----------
11995264
Elapsed: 00:00:12.46
SQL> select count(*) from SYSOBJECTS_FS ;
COUNT(*)
----------
11995264
Elapsed: 00:00:06.26
Is asm slower than zfs ?