Test your Storage I/O speed latency using oracle database

use below query to test you database server I/O

SET SERVEROUTPUT ON 
DECLARE 
lat INTEGER; 
iops INTEGER; 
mbps INTEGER; 
BEGIN 
-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<NUM_PHYSICAL_DISKS>, <MAX_LATENCY>, iops, mbps, lat); 
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (8, 10, iops, mbps, lat); 
DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops); 
DBMS_OUTPUT.PUT_LINE ('latency = ' || lat); 
dbms_output.put_line('max_mbps = ' || mbps); 
end; 
/