Oracle built-in IO test package dbms_resource_manager.CALIBRATE_IO

Oracle built-in IO test package dbms_resource_manager.CALIBRATE_IO oracle 11g started, launched the built-in IO test package, the principle is basically the same as the above mentioned Orion tool. Here is an example of specific use SQL> select group_number, name, total_mb, free_mb, total_mb-free_mb used_mb from v $ asm_disk_stat; export GROUP_NUMBER NAME TOTAL_MB FREE_MB USED_MB ------------ bytes ------------ ---------- 1 DATA_0002 511999 438029 73970 1 DATA_0003 511999 438022 73977 2 bytes 614399 549359 2 FRA_0001 65040 614399 1 D ATA_0001 511999 438035 73964 set timing on serveroutput on; SQL> declare 2 v_max_iops BINARY_INTEGER; 3 v_max_mbps BINARY_INTEGER; 4 rows BINARY_INTEGER; 5 begin 6 rows (6, 20, v_max_iops, v_max_mbps, v_act_lat); 7 dbms_output.put_line ('max iops: '| v_max_iops); 8 Gb/s ('max mbps:' | v_max_mbps); 9 dbms_output. Put_line ('actual latency: '| v_act_lat); 10 end; 11/www.2cto.com max iops: 9277max mbps: 549 actual latency: 20 PROCEDURE CALIBRATE_IO parameter name type input/output DEFAULT value ------------------------------ ----------------------- ------ -------- using BINARY_INTEGER in default MAX_LATENCY BINARY_INTEGER in default MAX_IOPS BINARY_INTEGER OUT MAX_MBPS BINARY_INTEGER OUT ACTUAL_LATENCY BINARY_INTEGER OU T. The running results can also be queried through the explain view to implement SQL> select * from orders; START_TIME END_TIME MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY limit www.2cto.com limit ---------- ------------ limit 03-7 ?? -12 09.42.42.414132 é? 03-7 ?? -12 09.54.10.118080? 9277 549 200 20 6 for more details, refer to the official oracle documentation http://docs.oracle.com/cd/E18283_01/server.112/e16638/iodesign.htm#insertedID3 Author hijk139