Re: Typical Read:Write ratio for transactions that actually hit the disk

William Fraker wrote:

> I am a networking expert and Oracle newbie trying to determine the
> ratio of Oracle reads to writes that actually hit the disk system
> (i.e. are not simply cache hits). I need this for evaluating the disk
> systems that I need for an Oracle database. (We don't have the Oracle
> DBAs yet).
>
> I need this because one particular disk system has substantially
> different performance numbers for read operations vs. write
> operations.
>
> I am sure that the numbers vary widely, but what are some "typical"
> ratios for OLTP systems? Thanks in advance.
>
> Will

There is no such thing as "typical" and no answer to your question. In fact even for a single application the numbers may vary greatly depending on the quality of the tuning. Throw in the differences between OLTP, OLAP, indexing, and size and it should be pretty obvious that the only way to know is to test on an application by application basis.

Daniel Morgan Received on Fri Sep 27 2002 - 11:20:17 CDT