Oracle IO性能测试

如果异步IO是关闭的，可以通过以下方式开启：

ALTER SYSTEM SET filesystemio_options=setall SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP；

测试脚本

SET SERVEROUTPUT ON
DECLARE
  l_latency    PLS_INTEGER;
  l_iops    PLS_INTEGER;
  l_mbps    PLS_INTEGER;
BEGIN
        DBMS_RESOURCE_MANAGER.calibrate_io (num_physical_disks => 1,
            max_latency            => 20,
            max_iops            => l_iops,
            max_mbps            => l_mbps,
            actual_latency        => l_latency);
   DBMS_OUTPUT.put_line(‘Max IOPS = ‘ || l_iops);
   DBMS_OUTPUT.put_line(‘Max MBPS = ‘ || l_mbps);
   DBMS_OUTPUT.put_line(‘Latency  = ‘ || l_latency);
 END;
/

结果输出样例

SYS@test1> SET SERVEROUTPUT ON
SYS@test1> 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 => 1,
  7                     max_latency                     => 20,
  8                     max_iops                        => l_iops,
  9                     max_mbps                        => l_mbps,
 10                     actual_latency          => l_latency);
 11     DBMS_OUTPUT.put_line(‘Max IOPS = ‘ || l_iops);
 12     DBMS_OUTPUT.put_line(‘Max MBPS = ‘ || l_mbps);
 13     DBMS_OUTPUT.put_line(‘Latency  = ‘ || l_latency);
 14   END;
 15  /
Max IOPS = 161
Max MBPS = 8
Latency  = 24

PL/SQL procedure successfully completed.

SYS@test1> /
Max IOPS = 107
Max MBPS = 8
Latency  = 18

PL/SQL procedure successfully completed.


SYS@test1> /
Max IOPS = 152
Max MBPS = 8
Latency  = 25

PL/SQL procedure successfully completed.

统计测试结果

测试结果在上边给出一组，就不全部放在这里了。

结果以下边表格统计可以做对比。

参考

https://rdcqii.hundsun.com/portal/article/578.html

https://blog.csdn.net/Hehuyi_In/article/details/89469534

https://oracle-base.com/articles/misc/measuring-storage-performance-for-oracle-systems#slob

Oracle IO性能测试

标签：介绍   节点   storage   ase   实例   工具介绍   脚本   oracle   media