Re: How to caliculate the IO Demand for IOPS and ThroughtPut

From: Ethan Post <post.ethan_at_gmail.com>
Date: Sat, 11 Jun 2011 02:24:14 -0500
Message-ID: <BANLkTi=_eC0Eg0KuMajA3k45Kn_zRGqXRg_at_mail.gmail.com>

If Oracle is the only major software running on the server you should be able to get this from just grabbing iostat and vmstat data. Oracle has a free tool called OSWatcher (Google it) which I run on most of my servers.

I would confirm the iostat data with data from gv$filestats and some of the values from gv$system_statistics for things like physical writes, reads, amount of redo generated to make sure they fall in line as I don't always trust the accounting I see in iostat.

If you have OEM/Grid Control installed you should be able to see all this stuff without homegrown scripts.

You could also run some ash reports during peak hours and see what that tells you. Look for ash* files in $ORACLE_HOME/rdbms/admin directory.

On Fri, Jun 10, 2011 at 3:26 PM, Vamshi Damidi <dbaprimatics_at_gmail.com>wrote:

> Hi All,
>
> We are currently on DAS file system and would like to move to SAN. and
> with New servers
> and we need to calculate the demand for IO and CPU so that we can design
> the disk architecture and buy the server accordingly.
> Please let me know if you need any more information.
>
> Any help would be greatfull.
>

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jun 11 2011 - 02:24:14 CDT