High latency on ODA X10-HA/HC
Hi Folks,
running DBMS_RESOURCE_MANAGER.calibrate_io inside a DBSystem gave the following results:
SET SERVEROUTPUT ON
SQL> DECLARE
2 l_latency PLS_INTEGER;
3 l_iops PLS_INTEGER;
4 l_mbps PLS_INTEGER;
5 BEGIN
6 DBMS_RESOURCE_MANAGER.calibrate_io (num_physical_disks => 18,
7 max_latency => 20,
8 max_iops => l_iops,
9 max_mbps => l_mbps,
10 actual_latency => l_latency);
11
12 DBMS_OUTPUT.put_line('Max IOPS = ' || l_iops);
13 DBMS_OUTPUT.put_line('Max MBPS = ' || l_mbps);
14 DBMS_OUTPUT.put_line('Latency = ' || l_latency);
15 END;
16 /
max_iops = 1235
latency = 61.971
max_mbps = 1037
Warning: Calibration results might be low because Instance Caging is enabled.
Consider re-running with Instance Caging disabled.