DBMS_RESOURCE_MANAGER.CALIBRATE_IOの使用
set serveroutput on
declare
    v_max_iops pls_integer:=1;
    v_max_mbps pls_integer:=1;
    v_actual_latency pls_integer:=1;
begin
    dbms_resource_manager.calibrate_io(
        max_iops=>v_max_iops,
        max_mbps=>v_max_mbps,
        actual_latency=>v_actual_latency);
        dbms_output.put_line('results follow: ');
        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_actual_latency);
end;
/

同期I/Oのデータベースで実行すると、下記のエラーが出てくる。
ORA-56708: Could not find any datafiles with asynchronous i/o capability
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License