How to calculate IOPS in Exadata ?

When we think to calculate IOPS , it seems very difficult task but it’s very easy to calculate in Exadata Storage. Let’s understand the procedure to calculate IOPS.

Well, first of all, execute the calibrate command on all available cell storage.

We are doing testing on Exadata Database Machine X3-2 1/8^th rack. Same procedure can be followed on any configuration of Exadata.

Cell Server 1

CellCLI> calibrate force

Calibration will take a few minutes...

Aggregate random read throughput across all hard disk LUNs: 1521 MBPS

Aggregate random read throughput across all flash disk LUNs: 8048.46 MBPS

Aggregate random read IOs per second (IOPS) across all hard disk LUNs: 2380

Aggregate random read IOs per second (IOPS) across all flash disk LUNs: 113116

Controller read throughput: 1974.08 MBPS

Cellcli - commands

Export 

CellCLI> export celldisk 

Import 

CellCLI> import celldisk 

Assign 

CellCLI> assign key 

Calibrate 

CellCLI> calibrate
CellCLI> calibrate force 

Set 

CellCLI> help set 
Usage: SET <variable> <value> 
Purpose: Sets a variable to alter the CELLCLI environment settings for your current session. 
Arguments: variable and value represent one of the following clauses: 
DATEFORMAT { STANDARD | LOCAL } 
ECHO { ON | OFF } 

Cellcli - Help

CellCLI> help

HELP [topic]

    Available Topics:

        ALTER

        ALTER ALERTHISTORY

        ALTER CELL

        ALTER CELLDISK

        ALTER GRIDDISK
        ALTER IBPORT

        ALTER IORMPLAN

        ALTER LUN
        ALTER PHYSICALDISK
        ALTER QUARANTINE

        ALTER THRESHOLD

        ASSIGN KEY

        CALIBRATE

        CREATE

        CREATE CELL

        CREATE CELLDISK

        CREATE FLASHCACHE

        CREATE GRIDDISK

        CREATE KEY
        CREATE QUARANTINE

        CREATE THRESHOLD

        DESCRIBE

        DROP

        DROP ALERTHISTORY

        DROP CELL

        DROP CELLDISK

        DROP FLASHCACHE

        DROP GRIDDISK
        DROP QUARANTINE

        DROP THRESHOLD

        EXPORT CELLDISK

        IMPORT CELLDISK

        LIST

        LIST ACTIVEREQUEST

        LIST ALERTDEFINITION

        LIST ALERTHISTORY

        LIST CELL

        LIST CELLDISK

        LIST FLASHCACHE

        LIST FLASHCACHECONTENT
        LIST GRIDDISK

        LIST IBPORT
        LIST IORMPLAN

        LIST KEY

        LIST LUN

        LIST METRICCURRENT

        LIST METRICDEFINITION

        LIST METRICHISTORY

        LIST PHYSICALDISK
        LIST QUARANTINE

        LIST THRESHOLD

        SET

        SPOOL

        START