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 

相关文章

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
Recreate quorum disk on X6-2
How to install/deploy Exadata
Exadata的特性
Exadata的扩展和级联
Exadata Diagnosing tools

联系我们

韩朝阳



    Phone:186-9589-1286

    E-mail:ohsdba@qq.com

    微  信: ohsdba


电话(186-9589-1286)

QQ(375349564)

微信(ohsdba)


常用链接

Oracle
eDelivery
My Oracle Support

Exadata 12.1 Document

Exadata 12.2 Document

Oracle 11gR2 Document

Oracle 12cR1 Document

Oracle 12cR2 Document

GoldenGate 12c

Oracle Fusion Middleware

Mysql Document

PostgreSQL

Python

github

sourceforge



Top
Cell186-9589-1286
QQ 375349564
E-mail ohsdba@qq.com