How To Calculate IOPS of an Oracle Database

IOPS (Input/Output Operations Per Second) is a common performance metric used to compare computer storage devices.

IOPS in Oracle databases is the total number of read and write requests of the database system per second. To maintain database performance, we must check whether our hardware is capable of processing the request generated by the database system.

These values ​​are in the dba_hist_sysmetric_summary table.

Find the IOPS value of the instance(since its started):

You can access the metric values between two dates by the following query:

You can also access all metric values from the Instance Activity Stats section of the AWR report.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

One comment

  1. in first script clause “group by METRIC_NAME” has been forgotten

Leave a Reply

Your email address will not be published. Required fields are marked *