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

From: William Fraker <wfraker_at_mailandnews.com>
Date: 27 Sep 2002 04:36:16 -0700
Message-ID: <d4d0a4c0.0209270336.3b4bd808@posting.google.com>

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 Received on Fri Sep 27 2002 - 06:36:16 CDT