Tuesday, March 6, 2012

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]

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...