Typical Read:Write ratios that actually hit the disk
From: William Fraker <wfraker_at_mailandnews.com>
Date: 26 Sep 2002 12:30:27 -0700
Message-ID: <d4d0a4c0.0209261130.7ec1ad6b_at_posting.google.com>
Date: 26 Sep 2002 12:30:27 -0700
Message-ID: <d4d0a4c0.0209261130.7ec1ad6b_at_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 Thu Sep 26 2002 - 21:30:27 CEST