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

From: Zhang Leyi (Kamus) <"Zhang>
Date: Sat, 11 Jun 2011 21:39:28 +0800
Message-Id: <C968A305-512C-48C7-9C6C-C3E4E87D8450_at_gmail.com>

If Karl Arao has seen this post, I'm sure he will recommend you to check his blog article: Workload characterization using DBA_HIST tables and kSar You can find it in: http://karlarao.wordpress.com/2010/01/31/workload-characterization-using-dba_hist-tables-and-ksar/

And also, he has written a couple of scripts to determine the system capacity which you can find in his shared Google Docs: http://docs.google.com/leaf?id=0B5H46jS7ZPdJMDEyMmYyYjEtZDA2MC00NWRlLWIzMWYtMWQyZDlmYTA5YWM1&hl=en

--
Zhang Leyi (Kamus) <kamusis_at_gmail.com>

Visit my blog for more : http://www.dbform.com
Join ACOUG: http://www.acoug.org



On Jun 11, 2011, at 3:24 PM, Ethan Post wrote:



> 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 - 08:39:28 CDT