Hi, On 5 Sep 2014, at 2:28 pm, Peter Ross <[email protected]> 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#PFGRF95222 [2] http://kevinclosson.net/slob/ _______________________________________________ luv-main mailing list [email protected] http://lists.luv.asn.au/listinfo/luv-main
