used a statement without predicate however the stats for predicate is increasing

Hello,

Please refer to below output

SQL> select b.value,a.name  from v$sysstat a,v$mystat b where a.statistic#=b.statistic# and (a.name in ('physical read total bytes','physical write total bytes') or a.name like '%cell phy%');

     VALUE NAME

---------- ----------------------------------------------------------------

109002752 physical read total bytes

         0 physical write total bytes

  48760376 cell physical IO interconnect bytes

         0 cell physical IO bytes saved during optimized file creation

         0 cell physical IO bytes saved during optimized RMAN file restore

  60375040 cell physical IO bytes eligible for predicate offload

         0 cell physical IO bytes saved by storage index

         0 cell physical IO bytes sent directly to DB node to balance CPU