--oracle database iops test
--第一个参数24是存储的物理硬盘数量,第二个参数是期望的延时10ms
sqlplus / as sysdba
set serveroutput on
declare
lat integer;
iops integer;
mbps integer;
begin
dbms_resource_manager.calibrate_io (24, 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;
/