Hi, On 5 Sep 2014, at 2:28 pm, Peter Ross <Petros.Listig@fdrive.com.au> wrote:
I am doing some research about "the best way" to give a partition to Oracle.
You want to provide an entire disk to Oracle Automatic Storage Management (ASM) and let it do all the heavy lifting for you. :) Whether this is DAS, SAN or iSCSI provided LUN.
Who’d’a thunk it?
Partitions do sector alignment which filesystems do not. Thus, this is not surprising given that most VM systems (and Oracle RDBMS) do DIRECT_IO to the underlying filesystem.
According to the benchmark above, a file exported as a blockdevice on top of a zvol could be better than an exported disk..
I doubt it would be for Oracle. You might want to check out ORION[1] or SLOB[2] as testing tools that reproduce Oracle-style disk I/O and report performance. You could create an iSCSI LUN from each of the options and do a comparison test to see which one performs best. Note that any statically assigned backing store should always outperform a dynamically sized store. Cheers, Avi [1] http://docs.oracle.com/cd/E11882_01/server.112/e16638/iodesign.htm#PFGRF9522... [2] http://kevinclosson.net/slob/