Storage Management (ASM ACFS DNFS ODM) (MOSC)

MOSC Banner

ASM vs ZFS

edited Jan 26, 2016 8:34PM in Storage Management (ASM ACFS DNFS ODM) (MOSC) 5 commentsAnswered

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 ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center