Matching storage stripe size with ASM allocation unit?

From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 23 May 2008 09:26:49 -0700 (PDT)
Message-ID: <91988.71333.qm@web80606.mail.mud.yahoo.com>


I heard an Oracle consultant suggest that the storage should be created with stripe size 1M for ASM, because the default ASM allocation unit (probably _asm_ausize) is 1M. He says most shops have much smaller stripe size. I asked since it's too late for the storage team, what if we lower our ASM allocation unit size? He gives no comment except he doesn't recommend.

Now I think about it. The ASM 1M allocation unit is for allocation or deallocation. It can't be I/O chunk size, which is still from db_block_size up to that multiplied by db_file_multiblock_read_count. The ideal stripe size may be typical I/O size dictated by the most frequently run SQL divided by number of disks in the striping setup (or larger than that). The ASM 1M size only plays a role when you create, resize or drop a datafile, not normally done anyway. Comments are welcome.

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 23 2008 - 11:26:49 CDT

Original text of this message