Testing cell offload / smart scan - Exadata X7/19c

Hello Everyone

We are trying to test the cell offloading / smart scan on one of our TEST databases running 19.19 DB on Exadata X7. We are using a table that has over 127 million rows

SQL> select count(*) from APP.TEST_REC;

 COUNT(*)

----------

 127,737,855

We ran it as follows

SQL> alter system flush buffer_cache;

System altered.

SQL> alter system flush SHARED_POOL;

System altered.

SQL> alter session set cell_offload_processing=FALSE;

Session altered.

set timing on

set autot on explain

SQL> select count(*) from APP.TEST_REC where id>100695569;

 COUNT(*)

----------

 28326985

Elapsed: 00:00:49.30

Execution Plan

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

Plan hash value: 2465216214

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

| Id | Operation         | Name       | Rows | Bytes | Cost (%CPU)| Time   |