Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Vertias ODM and Oracle 9i

Vertias ODM and Oracle 9i

From: Ralph <>
Date: 2 Dec 2004 03:18:50 -0800
Message-ID: <> (Ralph) wrote in message news:<>...
> Oracle (64-bit)
> Veritas version 1
> Solaris 9
> We have performed various tests on Oracle db_file_scattered_read
> performance in various combinations of:
> VxFS - with and without ODM
> VxVM partition - with and without ODM
> VTOC partition - with and without ODM
> and tried various combinations of db_block_size.
> Whilst we can get VxFS and any raw partition to perform IOs in
> db_file_multiblock_read_count * db_block_size requests, any use of ODM
> always results in the transfers being of db_block_size. This is
> clearly less effcient since more requests must be issued for this kind
> of read.
> This seems at odds with the documentation which claims that odm_io()
> will perform sequential reads/writes, direct read/writes, scattered
> reads, dbwr batch writes etc in the most efficient manner available.
> Is there any way that the behaviour of ODM can be influenced such that
> scattered reads are performed in db_file_multiblock_read_count *
> db_block_size requests?
> Cheers
> Ralph

Hi, Ralph,

I don't know the answer and I'm interested. But did you measure the overall performance of using and not using Veritas ODM when you run a batch job or a series of short transactions/queries? I'm reading They seem to be proud of simplifying I/O-related system calls (by saving the time to look up in the syscall dispatch table I think) and eliminating filesystem-related overheard (write locks, going through kernel page cache). In any case, overall performance comparison would be more appropriate than looking at whether it transfers only one db_block_size or not.

BTW, did you get that info by using ktrace, setting 10298 event or other means? Can you post somewhere all your benchmark results? Thanks.

Yong Huang


Sorry about the splitting of the is behaving strangely.

A summary of the results are available here

These were obtained by sar odmstat statspack etc.

We are only interested in the scattered read perfromance, rather than the overall IO performance.


Ralph Received on Thu Dec 02 2004 - 05:18:50 CST

Original text of this message