DBMS_RESOURCE_MANAGER.CALIBRATE_IO

admin

--recommandation ASYNCH or SETALL
select value from v$parameter where name='filesystemio_options';

--
col name format a50
SELECT name, asynch_io FROM v$datafile f,v$iostat_file i
  WHERE f.file#        = i.file_no
  AND   filetype_name  = 'Data File'
/

SET SERVEROUTPUT ON

--record time start
select to_char(sysdate,'yyyymmdd hh24:mi:ss') start_time from dual;

DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
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;
/

--record time end
select to_char(sysdate,'yyyymmdd hh24:mi:ss') start_time from dual;

--select results
select * from DBA_RSRC_IO_CALIBRATE;

--watch
watch -n 2 -d 'iostat -x'