Re: How to caliculate the IO Demand for IOPS and ThroughtPut
From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Mon, 20 Jun 2011 13:14:03 -0500
Message-ID: <BANLkTik5pcqKOaLy2MWLjVQWvcUy6JBHFw_at_mail.gmail.com>
Andrew-et all,
Date: Mon, 20 Jun 2011 13:14:03 -0500
Message-ID: <BANLkTik5pcqKOaLy2MWLjVQWvcUy6JBHFw_at_mail.gmail.com>
Andrew-et all,
You might see inflated IOPS when you use 'physical reads' or 'physical writes' in the equation. The metric 'physical reads' records the number of block requests and a block requests will always be higher than IO requests. Use 'physical read/write IO requests' while calculating disk IOPS.
Also disk IOPS might be significantly higher than the database IOPS when you add the RAID/parity overheads.
-Gopal
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 20 2011 - 13:14:03 CDT