CELL EFFICIENCY RATIO EXADATA

Often, when invoking cellcli utility in exadata storage server,you see a ratio banner called cell efficiency ratio(CER) after copyright message.Have you ever think of what it is and why has it been displayed everytime?

I see this banner everytime and ignore it because the ratio value is always small.But suddenly , i saw a huge rise in the CER due to some reason.I know that before i see this rise ,i had offloaded lot of sql queries with smart scan,storage index,HCC,flash cache keep etc.. This is the main reason for the huge increase in CER

To define CER, it is the ratio between the data touched on the storage tier and data processed on the database tier

CER = Data touched on storage cell/Data processed by database tier

In above picture,CER is 489 which means most data is processed by database itself or to be descriptive,less data is offloaded for smart scan,storage index is not efficiently used and touched from storage layer

CellCLI> list cell attributes offloadEfficiency
         489.3

Dont get frustated by seeing the low efficiency value but be happy that you dont have any negative values over there!Because negative value indicate that you dont use exadata upto the optimum level for what you pay

Though, CER is no longer increased in one day or night.The value gets better gradually on offloading data.

So always try to offload most of the oltp or batch workloads to the cell storage server and gradually increase CER for which you get blistering performance

The above output shows pretty impressive cell efficiency rate which shows that cell storage server is optimally used

CellCLI> list cell attributes offloadEfficiency
         16,291.9

Lot of objects are kept in flashcache to increase CER.For example, look the following output

The more objects you keep in flash memory,more IO is reduced for database

         
CellCLI> LIST FLASHCACHECONTENT detail

         cachedKeepSize:         0
         cachedSize:             65536
         dbID:                   3727006149
         dbUniqueName:           EXDBX
         hitCount:               2
         missCount:              0
         objectNumber:           87176
         tableSpaceNumber:       1

During the beginning of cell creation,CER is 1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s