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 exafusion参数在不同版本的变化
19c新特性之实时统计信息收集
Oracle Exadata x8m-2的更新
Oracle Exadata十年
Oracle Exadata x8-2的更新
终于等到你,Oracle 19c真的来了
useful mos note for exadata
Exadata最权威最完整的学习资料
Exadata上收集Cell节点的日志
Exadata上如何重置Cell节点root密码当你忘记时
Oracle性能加速之Write-Back Flash Cache
Exadata and ASM
Top