I/O Per Second (IOPS) Tips

welcome to http://www.startdays.com
welcome to http://www.ijachouf.com
welcome to http://www.swtools.biz
welcome to http://www.decoderhd.com

Oracle I/O Per Second (IOPS) Tips

Oracle Tips by Burleson Consulting
June 20, 2011

Question: How can I calculate my Oracle I/O per second? I know that
stats$sysstat can compute total I/O, but I need to calculate my I/O per
second using the AWR tables.

Answer: You can use the dba_hist_sysstat table to compute I/O per
second (IOPS).

If you donât want to write your own I/O per second script, see the
[49]Oracle script collection.
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------