Exadata Smart Scan - CELL_OFFLOAD_PLAN_DISPLAY parameter

If you want to control whether the offload status is show in execution plan set the parameter as below:

ALTER SYSTEM OR SESSION SET CELL_OFFLOAD_PLAN_DISPLAY=ALWAYS;

The value options for this parameter are:
AUTO -> display the predicate if cell is present and table is on the cell
ALWAYS -> always show
NEVER -> never show offload status


Some views that can be used to gather cell statistics information:

V$SQLAREA
V$SQLSTATS
V$SQLAREA_PLAN_HASH
V$SQLSTATS_PLAN_HASH


on columns like :

IO_CELL_OFFLOAD_ELIGIBLE_BYTES
IO_CELL_OFFLOAD_RETURNED_BYTES



Best Regards,
Paulo Portugal