Focus On Oracle

Installing, Backup & Recovery, Performance Tuning,
Troubleshooting, Upgrading, Patching

Oracle Engineered System


当前位置: 首页 » 技术文章 » 性能优化

Exadata IO性能如何

下面的输出为X6-2八分之一配(8T 7200rpm)calibrate force的输出

****************xd06cel01*****************
Command: cellcli -e calibrate force
Calibration will take a few minutes...
Aggregate random read throughput across all hard disk LUNs: 1004 MBPS
Aggregate random read throughput across all flash disk LUNs: 9236 MBPS
Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 1647
Calibrating hard disks (read only) ...
LUN 0_0 on drive [8:0      ] random read throughput: 171.00 MBPS, and 276 IOPS
LUN 0_1 on drive [8:1      ] random read throughput: 171.00 MBPS, and 276 IOPS
LUN 0_2 on drive [8:2      ] random read throughput: 171.00 MBPS, and 277 IOPS
LUN 0_3 on drive [8:3      ] random read throughput: 171.00 MBPS, and 276 IOPS
LUN 0_4 on drive [8:4      ] random read throughput: 170.00 MBPS, and 276 IOPS
LUN 0_5 on drive [8:5      ] random read throughput: 172.00 MBPS, and 275 IOPS
Calibrating flash disks (read only, note that writes will be significantly slower) ...
LUN 2_1 on drive [FLASH_2_1] random read throughput: 4,656.00 MBPS, and 403067 IOPS
LUN 5_1 on drive [FLASH_5_1] random read throughput: 4,721.00 MBPS, and 407097 IOPS
CALIBRATE results are within an acceptable range.
Calibration has finished.
********************************************

****************xd06cel02*****************
Command: cellcli -e calibrate force
Calibration will take a few minutes...
Aggregate random read throughput across all hard disk LUNs: 936 MBPS
Aggregate random read throughput across all flash disk LUNs: 9031 MBPS
Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 1638
Calibrating hard disks (read only) ...
LUN 0_0 on drive [8:0      ] random read throughput: 170.00 MBPS, and 274 IOPS
LUN 0_1 on drive [8:1      ] random read throughput: 168.00 MBPS, and 274 IOPS
LUN 0_2 on drive [8:2      ] random read throughput: 172.00 MBPS, and 277 IOPS
LUN 0_3 on drive [8:3      ] random read throughput: 166.00 MBPS, and 276 IOPS
LUN 0_4 on drive [8:4      ] random read throughput: 172.00 MBPS, and 279 IOPS
LUN 0_5 on drive [8:5      ] random read throughput: 173.00 MBPS, and 274 IOPS
Calibrating flash disks (read only, note that writes will be significantly slower) ...
LUN 2_1 on drive [FLASH_2_1] random read throughput: 4,523.00 MBPS, and 401451 IOPS
LUN 5_1 on drive [FLASH_5_1] random read throughput: 4,759.00 MBPS, and 408027 IOPS
CALIBRATE results are within an acceptable range.
Calibration has finished.
********************************************

****************xd06cel03*****************
Command: cellcli -e calibrate force
Calibration will take a few minutes...
Aggregate random read throughput across all hard disk LUNs: 949 MBPS
Aggregate random read throughput across all flash disk LUNs: 9216 MBPS
Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 1646
Calibrating hard disks (read only) ...
LUN 0_0 on drive [8:0      ] random read throughput: 169.00 MBPS, and 275 IOPS
LUN 0_1 on drive [8:1      ] random read throughput: 171.00 MBPS, and 275 IOPS
LUN 0_2 on drive [8:2      ] random read throughput: 172.00 MBPS, and 275 IOPS
LUN 0_3 on drive [8:3      ] random read throughput: 172.00 MBPS, and 272 IOPS
LUN 0_4 on drive [8:4      ] random read throughput: 169.00 MBPS, and 277 IOPS
LUN 0_5 on drive [8:5      ] random read throughput: 171.00 MBPS, and 277 IOPS
Calibrating flash disks (read only, note that writes will be significantly slower) ...
LUN 2_1 on drive [FLASH_2_1] random read throughput: 4,745.00 MBPS, and 405883 IOPS
LUN 5_1 on drive [FLASH_5_1] random read throughput: 4,650.00 MBPS, and 399733 IOPS
CALIBRATE results are within an acceptable range.
Calibration has finished.
********************************************
创建表空间耗时
SQL> alter tablespace APPS_DATA add datafile '+DATA' size 16G;

Tablespace altered.

Elapsed: 00:00:09.73
SQL> 

SQL> begin
for i in 1..25 loop
execute immediate 'alter tablespace APPS_DATA add datafile '||q'['+DATA']'||' size 16G';
end loop;
end;
/  2    3    4    5    6

PL/SQL procedure successfully completed.

Elapsed: 00:04:06.57
SQL>
一个16G大小的数据文件,不到10秒就创建完成了,存储节点配置了高容量盘(8T,7200rpm)



关键词:perf exadata 

相关文章

Exadata最权威最完整的学习资料
Exadata上收集Cell节点的日志
Exadata上如何重置Cell节点root密码当你忘记时
Oracle性能加速之Write-Back Flash Cache
Exadata and ASM
Oracle ZDLRA (Zero Data Lost Recovery Appliance) FAQ
Oracle ZDLRA (Zero Data Lost Recovery Appliance) Features
Oracle Database 18c On Exadata
Migrate Oracle Database on AIX to Exadata
ExaWatcher Charts
qperf & iperf
How to config IB network listener
Top
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com