Showing posts with label Cell offload. Show all posts
Showing posts with label Cell offload. Show all posts

What is Cell Efficiency Ration in Exadata?

If you have observed, when we invoke CELLCLI utility, it use to display Cell Efficiency Ratio in banner. Example given below.


So what does cell efficiency ratio indicate?

It is the ratio between data accessed by the storage cell and data processed by the database for the cell. Higher the value greater the I/O savings as a result of offloading.

The Cell Efficiency Ratio is same as the value displayed for offloadEfficiency in CELLCLI>LIST CELL DETAIL as below


Then the ratio of the total MB accessed on the cell to the MB accessed on the host (for the cell) is computed every minute that CELLSRV is active by Management Server (MS). 

It is difficult to explain as there is no manual intervention we can do nor we can fetch detailed result of it. We can use it for reference purpose only as there is no practical value from performance perspective of Exadata. 

How Exadata Cell Offloading Works ?

First let's know what is offloading and benefit of cell offloading in Exadata?

What is Cell Offloading :-

It refers to the fact that part of the traditional SQL processing done by the database can be “offloaded” from the database layer to the storage layer.

Benefit: The primary benefit of Offloading is the reduction in the volume of data that must be returned to the database server. This is one of the major bottlenecks of most  large databases.


Below is the example of cell offloading.

We have created table cell_offload with 20 lac records.

#### Checking the cell offloading process in DB parameter  ####


SQL> show parameter cell_offload_processing

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
cell_offload_processing              boolean     TRUE


# Flush buffer_cache and shared_pool to get exact result of offloading scenario #


SQL> alter system flush buffer_cache;

System altered.

SQL>  alter system flush SHARED_POOL;

System altered.


## Disabling Cell_offloading_process and checking the query result ##