DBMS_COMPRESSION package helps to determine the expected compression level. COMPRESSION and COMPRESS_FOR column of user_tables provides whether compression is enabled or disabled and compression method respectively

The CELL_OFFLOAD_PROCESSING parameter controls whether predicate filtering and other operations are offloaded to Exadata storage cells. This parameter can be set at system or session level and overrides the default behavior of using cell offload capabilities. The other options (CELL_OFFLOAD_PLAN_DISPLAY, OPT_PARAM, CELL_PARTITION_LARGE_EXTENTS) are not the correct parameter names for controlling cell offload processing behavior.