How to calculate IOPS in oracle?

IOPS (Input/Output Operations Per Second, pronounced eye-ops) is a common performance measurement used to benchmark computer storage devices like hard disk drives (HDD), solid state drives (SSD), and storage area networks (SAN). (From

But in Oracle database  we measure how much of such requests are generated by the database system. We have to check whether  our hardware are capable of processing the request generated by the database system in order to maintain the performance.

IOPS is calculated in Oracle database as the sum of  "Physical Read Total IO Requests Per Sec" and "Physical Write Total IO Requests Per Sec"

These values will be available in the table, dba_hist_sysmetric_summary

Here is a query to find IOPS in Oracle

break on report
compute sum of Value on report
select METRIC_NAME,avg(AVERAGE) as "Value"
   from dba_hist_sysmetric_summary
   where METRIC_NAME in ('Physical Read Total IO Requests Per Sec','Physical Write Total IO Requests Per Sec')
   group by METRIC_NAME;

Read this PDF for more information:

No comments:

Post a Comment