MAX_LATENCY (the maximum latency for disk access, in milliseconds)

11g Calibrate I/O

Can someone help me find the right value for MAX_LATENCY.

Is there a query or something that I can run and come-up with a value for MAX_LATENCY ?

Below is the syntax that I picked up from (Doc ID 727062.1)

SET SERVEROUTPUT ON

DECLARE

lat INTEGER;

iops INTEGER;

mbps INTEGER;

BEGIN

--DBMS_RESOURCE_MANAGER.CALIBRATE_IO(<NUM_DISKS>, <MAX_LATENCY>,

iops, mbps, lat);

DBMS_RESOURCE_MANAGER.CALIBRATE_IO (28, 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;

/