ODA IO performance summary

Oracle Database Appliance IO performance was measured with different tools: Orion, Calibrate, oakcli.
Here is summary:





Despite of ORION documentation examples showed against raw (character) devices I used block devices (first column) because Linux deprecated raw devices.
 SAS Disks were tested with 8K block size.

SSD columns:
Because of 512b redo log block size I wanted to measure SSD performance for 512 bytes blocks. But ORION don't have the 512 bytes block size. The 1K is minimum.The steps are:
- 1K - because it nearest to the 512b
- 4K - because it is default SSD block size, so this size is optimal for IO operations
- 8K - for comparison purposes. If you put db file on SSD. 

Calibrate IO:
I thinks that number of IOPS=14238 is double measured mistake .
The more real number is an half of this value 7119 ( theoretical value is: 20 disks * 320 IOPS = 6400 IOPS) . Calibrate_IO uses database block size, the 8K in our case.

ODA IO performance oakcli example

ODA-факты о производительности Oracle Database Appliance:

[root@oda01-pub1 orion]# oakcli validate -c DiskCalibration
 
INFO: Doing oak disk calibration checks
INFO: About to run random read IOPS throughput tests for SASDisk
RESULT: Random read throughput across all 20 SASDisk = 4238 IOPS
INFO: About to run random read IOPS throughput tests for SSDDisk
RESULT: Random read throughput across all 4 SSDDisk = 16540 IOPS
INFO: About to run random read MBPS throughput tests for SASDisk
RESULT: Random read throughput across all 20 SASDisk = 2003 MBPS
INFO: About to run random read MBPS throughput tests for SSDDisk
RESULT: Random read throughput across all 4 SSDDisk = 994 MBPS
 
INFO: Completed IOPS tests for individual disks of type SASDisk
INFO: Completed MBPS tests for individual disks of type SASDisk
INFO: Completed IOPS tests for individual disks of type SSDDisk
INFO: Completed MBPS tests for individual disks of type SSDDisk
INFO: Completed all single disk tests INFO: Calibration results for SASDisk
RESULT: Random read throughput of HDD_E0_S05_984692403 is 308 IOPS 166 MBPS
RESULT: Random read throughput of HDD_E0_S13_979803779 is 308 IOPS 170 MBPS
RESULT: Random read throughput of HDD_E0_S17_979676671 is 311 IOPS 165 MBPS
RESULT: Random read throughput of HDD_E1_S03_984701491 is 300 IOPS 163 MBPS
RESULT: Random read throughput of HDD_E1_S06_984565747 is 310 IOPS 164 MBPS
RESULT: Random read throughput of HDD_E0_S00_984624147 is 305 IOPS 163 MBPS
RESULT: Random read throughput of HDD_E0_S04_984667927 is 305 IOPS 162 MBPS
RESULT: Random read throughput of HDD_E0_S09_984559543 is 308 IOPS 167 MBPS
RESULT: Random read throughput of HDD_E0_S08_984624267 is 309 IOPS 167 MBPS
RESULT: Random read throughput of HDD_E1_S11_984698091 is 311 IOPS 168 MBPS
RESULT: Random read throughput of HDD_E1_S14_979827203 is 309 IOPS 165 MBPS
RESULT: Random read throughput of HDD_E0_S01_984620575 is 304 IOPS 166 MBPS
RESULT: Random read throughput of HDD_E0_S16_979799899 is 308 IOPS 165 MBPS
RESULT: Random read throughput of HDD_E1_S02_984694595 is 305 IOPS 163 MBPS
RESULT: Random read throughput of HDD_E1_S15_979832135 is 312 IOPS 167 MBPS
RESULT: Random read throughput of HDD_E1_S18_979853447 is 310 IOPS 164 MBPS
RESULT: Random read throughput of HDD_E1_S19_979811875 is 310 IOPS 166 MBPS
RESULT: Random read throughput of HDD_E1_S10_984691531 is 312 IOPS 165 MBPS
RESULT: Random read throughput of HDD_E1_S07_985110727 is 309 IOPS 166 MBPS
RESULT: Random read throughput of HDD_E0_S12_979857635 is 309 IOPS 164 MBPS
INFO: Calibration results for SSDDisk
RESULT: Random read throughput of SSD_E0_S21_805674938 is 4442 IOPS 338 MBPS
RESULT: Random read throughput of SSD_E0_S20_805674689 is 4436 IOPS 337 MBPS
RESULT: Random read throughput of SSD_E1_S22_805674773 is 4439 IOPS 336 MBPS
RESULT: Random read throughput of SSD_E1_S23_805674697 is 4453 IOPS 338 MBPS

Кстати, весьма рекомендую для прочтения:
Inside the Oracle Database Appliance (ODA) [ID 1385831.1]