oracle i/o压力测试

oracle i/0压力测试
DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
DBMS_RESOURCE_MANAGER.CALIBRATE_IO(4, 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;
/

set lines 200
col START_TIME for a28
col END_TIME for a28
col ADDITIONAL_INFO for a15
select * from dba_rsrc_io_calibrate;

START_TIME END_TIME MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY NUM_PHYSICAL_DISKS ADDITIONAL_INFO

---

26-SEP-22 08.49.36.277170 AM 26-SEP-22 09.00.36.701162 AM 118699 3398 2808 1.187 4