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

For data collection

dba_hist_sysmetric_summary- gives max, min, averages, stddev, etc for every hour for last week in AWR by default.

V$SYSMETRIC_HISTORY - max, min, avg, stddev etc for every minute for last hour. You can also pull out stats for every 15 secs for last 3 minutes.

I'd expect I/O to be less on disk if you are not using direct I/O many reads will come from UNIX file cache.
Even with direct I/O many reads will be coming from SAN cache. Then again SANs will do read aheads that might never get used by Oracle.

Also, for RAID5, I'd only expect 3x the IOPs for writes ( read, write, write vs write ) only.

Oracle can do a lot more I/O than just data block and redo operations. Check the stats

physical read IO requests
vs
physical read total IO requests

physical read bytes
vs
physical read total byte

• Kyle http://dboptimizer.com

On Thu, Jun 23, 2011 at 12:48 PM, Karl Arao <karlarao_at_gmail.com> wrote:

> Hi Robin,
>
> Yes I agree, the average normalizes the spikes.. so it's also good to have
> a validation of the IO numbers you are getting from Oracle from the OS
> numbers.
>
> Also I use these statistical tools for my data points
> http://karlarao.tiddlyspot.com/#dbms_stat_funcs
> this one is from Craig Shallahamer gives you a really nice visual
> distribution of your data points, I modified it a bit so he got that
> uploaded on his site already..
> http://resources.orapub.com/product_p/statsam.htm
>
> And.. another thing that you can do when you are investigating on a slow
> subsystem and drilling down on a subsecond detail is to trace the session
> and use the Mr. Tools.. particularly the Mr. Skew.. ;) you can do a lot of
> statistical drill downs on 10046 trace using that tool
> http://karlarao.tiddlyspot.com/#%5B%5BMr.%20Tools%5D%5D
>
>
> --
> Karl Arao
> karlarao.wordpress.com
> karlarao.tiddlyspot.com
>

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