Re: How to caliculate the IO Demand for IOPS and ThroughtPut
- From: "Zhang Leyi (Kamus)" <kamusis@xxxxxxxxx>
- To: post.ethan@xxxxxxxxx
- Date: Sat, 11 Jun 2011 21:39:28 +0800
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@xxxxxxxxx>
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@xxxxxxxxx> 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.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
