oracle 11g 存储IO性能压测方式
Oracle 11g 提供了IO压测工具DBMS_RESOURCE_MANAGER.CALIBRATE_IO PL/SQL 存储过程,可以用于测试存储IO性能(IOPS、IO延迟、IO吞吐量)
存储过程参数如下:
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (
num_physical_disks IN PLS_INTEGER DEFAULT 1,
max_latency IN PLS_INTEGER DEFAULT 20,
max_iops OUT PLS_INTEGER,
max_mbps OUT PLS_INTEGER,
actual_latency OUT PLS_INTEGER);
SQL> SET SERVEROUTPUT ON
DECLARE
lat INTEGER;
iops INTEGER;
mbps INTEGER;
BEGIN
-- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (<DISKS>, <MAX_LATENCY>, iops, mbps, lat);
DBMS_RESOURCE_MANAGER.CALIBRATE_IO (24, 10, iops, mbps, lat);
DBMS_OUTPUT.PUT_LINE ('maSQL> 2 3 4 5 6 7 8 9 x_iops = ' || iops);
DBMS_OUTPUT.PUT_LINE ('latency = ' || lat);
DBMS_OUTPUT.PUT_LINE ('max_mbps = ' || mbps);
end;
/ 10 11 12 13
max_iops = 8845
latency = 8
max_mbps = 1141
PL/SQL procedure successfully completed.
也可以通过查询视图获取压测的IO性能数据:
select * from dba_rsrc_io_calibrate
本文来自博客园,作者:踏雪无痕2017,转载请注明原文链接:https://www.cnblogs.com/oradba/p/14573106.html