Oracle Database iops Measurement

IOPS (Input/Output Operations Per Second) is the number of read/write (I/O) Operations Per Second. It is mostly used in databases and other occasions to measure the performance of random access. The storage IOPS performance is different from the host I/O. IOPS refers to the number of accesses allowed by the host per second. Only one IO of the host can be completed after multiple accesses to the storage. For example, when a host writes a minimum data block, it must go through three steps, namely, sending write requests, writing data, and receiving write confirmation.

SQL> SET SERVEROUTPUT ON
DECLARE
Lat INTEGER;
Iops INTEGER;
Mbps INTEGER;
BEGIN
-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat );
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (1, 20, iops, mbps, lat );
DBMS_OUTPUT.PUT_LINE ('max _ iops = '| iops );
DBMS_OUTPUT.PUT_LINE ('latency = '| lat );
Dbms_output.put_line ('max _ mbps = '| mbps );
End;
/

Max_iops = 1, 1045
Latency = 20
Max _ Mbps = 122

PL/SQL procedure successfully completed.