set timing on serveroutput on
declare
v_max_iops BINARY_INTEGER;
v_max_mbps BINARY_INTEGER;
v_act_lat BINARY_INTEGER;
begin
dbms_resource_manager.CALIBRATE_IO(num_physical_disks => 1,
max_latency => 10,
max_iops => v_max_iops,
max_mbps => v_max_mbps,
actual_latency => v_act_lat);
dbms_output.put_line('max iops : ' || v_max_iops);
dbms_output.put_line('max mbps : ' || v_max_mbps);
dbms_output.put_line('actual latency : ' || v_act_lat);
end;
/
max iops : 53669
max mbps : 747
actual latency : 9
iostat -xm fioa 1
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
fioa 0.00 0.00 53123.00 3.00 415.05 0.04 16.00 157.39 2.96 0.02 100.10
avg-cpu: %user %nice %system %iowait %steal %idle
7.87 0.00 11.31 49.91 0.00 30.92
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
fioa 0.00 0.00 6663.00 0.00 761.75 0.00 234.14 25.88 3.89 0.15 100.10
avg-cpu: %user %nice %system %iowait %steal %idle
0.62 0.00 2.49 10.85 0.00 86.03
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
fioa 0.00 0.00 6659.00 3.00 760.62 0.04 233.84 26.19 3.93 0.15 100.10
ORACLE的等待事件
20 10129 Disk file I/O Calibration 1 0 0 451
244 10127 Disk file I/O Calibration 1 0 0 451
36 10101 Disk file I/O Calibration 1 0 0 452
52 10103 Disk file I/O Calibration 1 0 0 452
66 10105 Disk file I/O Calibration 1 0 0 452
81 10107 Disk file I/O Calibration 1 0 0 452
100 10109 Disk file I/O Calibration 1 0 0 452
116 10111 Disk file I/O Calibration 1 0 0 452
131 10113 Disk file I/O Calibration 1 0 0 452
148 10115 Disk file I/O Calibration 1 0 0 452
162 10099 Disk file I/O Calibration 1 0 0 452
163 10117 Disk file I/O Calibration 1 0 0 452
180 10119 Disk file I/O Calibration 1 0 0 452
195 10121 Disk file I/O Calibration 1 0 0 452
211 10123 Disk file I/O Calibration 1 0 0 452
228 10125 Disk file I/O Calibration 1 0 0 452