d.name,

i.asynch_ioFROMv$datafile d,

v$iostat_file iWHERE d.file# =i.file_noAND i.filetype_name = ‘Data File‘;

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

ALTER SYSTEM SET filesystemio_options=setall SCOPE=SPFILE;SHUTDOWNIMMEDIATE;

STARTUP；

测试脚本

SET SERVEROUTPUT ON

DECLAREl_latency PLS_INTEGER;

l_iops PLS_INTEGER;

l_mbps PLS_INTEGER;BEGINDBMS_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 ONSYS@test1> DECLARE

2l_latency PLS_INTEGER;3l_iops PLS_INTEGER;4l_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 = 8Latency= 24PL/SQL proceduresuccessfully completed.

SYS@test1> /

Max IOPS = 107

Max MBPS = 8Latency= 18PL/SQL proceduresuccessfully completed.

SYS@test1> /

Max IOPS = 152

Max MBPS = 8Latency= 25PL/SQL procedure successfully completed.

统计测试结果

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

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

指标

single-DB

RAC-DB1

RAC-DB2

最大IOPS

518

445

469

161

107

152

13290

12587

12937

12811

最大吞吐量

92

96

92

8

8

8

106

108

107

107

平均延迟

5

6

5

24

18

25

18

18

19

20

参考

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

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：https://www.cnblogs.com/PiscesCanon/p/12865431.html