SQL performance

Hi

With sql statement plan going for "cell smart table scan". performance got degraded and request is not getting completed.

By using below query, verified query is doing offloading .

is there any way we can check why performance degraded with cell smart table space.

SQL> set pagesize 999

set lines 190

SQL> SQL> col sql_text format a70 trunc

col child format 99999

col execs format 9,999

SQL> SQL> SQL> col avg_etime format 99,999.99

col "IO_SAVED_%" format 999.99

col avg_px format 999

col offload for a7

select sql_id, child_number child, plan_hash_value plan_hash, executions execs,

(elapsed_time/1000000)/decode(nvl(executions,0),0,1,executions)/