We have a question on Cell Offloading in Exadata. I confirmed that the init parameter "cell_offload_processing" is set to True at the instances level. When I run
a select * from a large table however, it is not doing Cell Offload as it is supposed to. We are trying to find out the reason for this:
SQL_ID
CHILD PLAN_HASH EXECS AVG_ETIME AVG_PX OFFLOAD IO_SAVED_%
SQL_TEXT
-------------
------ ---------- ------ ---------- ------ ------- ----------
----------------------------------------------------------------------
9g57s51qkj1wy 0
4273800425
1 .04 0
No .00
select * from xx_bcb.BCB_UNBILLED_LINES_ALL