Calibrate测试Exadata IO

以下同时使用cellcli calibrate和 DBMS_RESOURCE_MANAGER.CALIBRATE_IO包测试 Exadata IO， Exadata为X2-2 1/4 RAC:   CellCLI: Release 11.2.3.1.1 - Production on Mon Dec 03 00:32:27 EST 2012 Copyright (c) 2007, 2011, Oracle. All rights reserved. Cell Efficiency Ratio: 617 CellCLI> calibrate force; Calibration will take a few minutes... Aggregate random read throughput across all hard disk LUNs: 1921 MBPS Aggregate random read throughput across all flash disk LUNs: 4164.33 MBPS Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 4971 Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 145195 Controller read throughput: 1919.64 MBPS Calibrating hard disks (read only) ... LUN 0_0 on drive [28:0 ] random read throughput: 168.12 MBPS, and 430 IOPS LUN 0_1 on drive [28:1 ] random read throughput: 164.23 MBPS, and 423 IOPS LUN 0_10 on drive [28:10 ] random read throughput: 170.80 MBPS, and 433 IOPS LUN 0_11 on drive [28:11 ] random read throughput: 168.32 MBPS, and 421 IOPS LUN 0_2 on drive [28:2 ] random read throughput: 170.07 MBPS, and 431 IOPS LUN 0_3 on drive [28:3 ] random read throughput: 169.82 MBPS, and 421 IOPS LUN 0_4 on drive [28:4 ] random read throughput: 165.17 MBPS, and 417 IOPS LUN 0_5 on drive [28:5 ] random read throughput: 166.82 MBPS, and 429 IOPS LUN 0_6 on drive [28:6 ] random read throughput: 170.85 MBPS, and 430 IOPS LUN 0_7 on drive [28:7 ] random read throughput: 168.42 MBPS, and 429 IOPS LUN 0_8 on drive [28:8 ] random read throughput: 169.78 MBPS, and 428 IOPS LUN 0_9 on drive [28:9 ] random read throughput: 168.77 MBPS, and 430 IOPS Calibrating flash disks (read only, note that writes will be significantly slower) ... LUN 1_0 on drive [FLASH_1_0] random read throughput: 271.01 MBPS, and 19808 IOPS LUN 1_1 on drive [FLASH_1_1] random read throughput: 270.24 MBPS, and 19821 IOPS LUN 1_2 on drive [FLASH_1_2] random read throughput: 270.41 MBPS, and 19844 IOPS LUN 1_3 on drive [FLASH_1_3] random read throughput: 270.37 MBPS, and 19812 IOPS LUN 2_0 on drive [FLASH_2_0] random read throughput: 272.32 MBPS, and 20634 IOPS LUN 2_1 on drive [FLASH_2_1] random read throughput: 272.12 MBPS, and 20635 IOPS LUN 2_2 on drive [FLASH_2_2] random read throughput: 272.28 MBPS, and 20676 IOPS LUN 2_3 on drive [FLASH_2_3] random read throughput: 272.43 MBPS, and 20669 IOPS LUN 4_0 on drive [FLASH_4_0] random read throughput: 271.13 MBPS, and 19802 IOPS LUN 4_1 on drive [FLASH_4_1] random read throughput: 271.90 MBPS, and 19799 IOPS LUN 4_2 on drive [FLASH_4_2] random read throughput: 271.42 MBPS, and 19798 IOPS LUN 4_3 on drive [FLASH_4_3] random read throughput: 272.25 MBPS, and 19808 IOPS LUN 5_0 on drive [FLASH_5_0] random read throughput: 272.22 MBPS, and 19824 IOPS LUN 5_1 on drive [FLASH_5_1] random read throughput: 272.44 MBPS, and 19823 IOPS LUN 5_2 on drive [FLASH_5_2] random read throughput: 271.83 MBPS, and 19808 IOPS LUN 5_3 on drive [FLASH_5_3] random read throughput: 271.73 MBPS, and 19837 IOPS CALIBRATE results are within an acceptable range. Calibration has finished.   set serveroutput on; DECLARE lat INTEGER; iops INTEGER; mbps INTEGER; BEGIN -- DBMS_RESOURCE_MANAGER.CALIBRATE_IO (disk_count,max_latency , iops, mbps, lat); DBMS_RESOURCE_MANAGER.CALIBRATE_IO (20, 15, iops, mbps, lat); DBMS_OUTPUT.PUT_LINE ('max_iops = ' || iops); DBMS_OUTPUT.PUT_LINE ('latency = ' || lat); dbms_output.put_line('max_mbps = ' || mbps); end; / max_iops = 27176 latency = 4 max_mbps = 4280 PL/SQL procedure successfully completed.     SQL> col start_time for a10; SQL> col end_time for a10; SQL> select * from DBA_RSRC_IO_CALIBRATE; START_TIME END_TIME MAX_IOPS MAX_MBPS MAX_PMBPS LATENCY NUM_PHYSICAL_DISKS ---------- ---------- ---------- ---------- ---------- ---------- ------------------ 00:42 00:58 27176 4280 511 4 20