• For transfer 1 GB amount of data if transfer rate is 100Mbps then it would completed within 1 Minutes and 30 seconds
  • For transfer 1 GB amount of data if transfer rate is 50Mbps then it would completed within 3 Minutes.


Measuring Storage Performance – Oracle Database

Oracle Orion is a tool for predicting the performance of an Oracle database without having to install Oracle or create a database. Unlike other I/O calibration tools, Oracle Orion is expressly designed for simulating Oracle database I/O workloads using the same I/O software stack as Oracle.

Measuring Storage Performance For Oracle Systems

Hard disk drive performance comparision

Device Type IOPS Interface Notes
7,200 rpm SATA drives HDD ~75-100 IOPS[2] SATA 3 Gbit/s
10,000 rpm SATA drives HDD ~125-150 IOPS[2] SATA 3 Gbit/s
10,000 rpm SAS drives HDD ~140 IOPS[2] SAS
15,000 rpm SAS drives HDD ~175-210 IOPS[2] SAS


Typical HDD figures
latency [ms]
4,200 7.14
5,400 5.56
7,200 4.17
10,000 3.00
15,000 2.00

H/W Evaluation

dmidecode – DMI table decoder

[root@csmsrv-4frh64-nuxeosvn ~]# dmidecode --type
dmidecode: option '--type' requires an argument
Type number or keyword expected
Valid type keywords are:

dmidecode --type bios
# dmidecode 2.11
SMBIOS 2.7 present.

Handle 0x0000, DMI type 0, 24 bytes
BIOS Information
        Vendor: FUJITSU // American Megatrends Inc.
        Version: V4.6.4.1 R1.18.0 for D3034-A1x
        Release Date: 11/03/2011
        Address: 0xF0000
        Runtime Size: 64 kB
        ROM Size: 8192 kB
                PCI is supported
                BIOS is upgradeable
                BIOS shadowing is allowed
                Boot from CD is supported
                Selectable boot is supported
                EDD is supported
                Print screen service is supported (int 5h)
                8042 keyboard services are supported (int 9h)
                Serial services are supported (int 14h)
                Printer services are supported (int 17h)
                ACPI is supported
                USB legacy is supported
                BIOS boot specification is supported
                Targeted content distribution is supported
                UEFI is supported
        BIOS Revision: 1.18

lscpu – display information about the CPU architecture

Check type of Hardisk

smartctl - Control and Monitor Utility for SMART Disks

smartctl -i /dev/sda
smartctl 5.43 2012-06-30 r3573 [x86_64-linux-2.6.32-358.el6.x86_64] (local build)
Copyright (C) 2002-12 by Bruce Allen,

Vendor:               LSI
Product:              RAID 5/6 SAS 6G
Revision:             2.90
User Capacity:        748,532,269,056 bytes [748 GB]
Logical block size:   512 bytes
Logical Unit id:      0x6003005701451dd0173e81e95f57f757
Serial number:        0057f7575fe9813e17d01d4501570003
Device type:          disk
Local Time is:        Wed Jul  9 14:40:41 2014 IST
Device does not support SMART

Storage selection IOPS calculation

[gview file=””]

10,000 rpm SAS drives HDD ~140     IOPS[2] SAS
15,000 rpm SAS drives HDD ~175-210 IOPS[2]SAS