查询有多少物理盘:
select group_number, name, total_mb, free_mb, total_mb-free_mb used_mb from v$asm_disk_stat;
执行calibrate io包:
set timing on
set serveroutput on
declare
v_max_iops BINARY_INTEGER;
v_max_mbps BINARY_INTEGER;
v_act_lat BINARY_INTEGER;
begin
dbms_resource_manager.CALIBRATE_IO(1,10,v_max_iops,v_max_mbps,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;
/