drop table esfc_test_t; 

create table esfc_test_t as select * from keep_test_base; 

rem exec  dbms_stats.gather_table_stats(ownname=>user,tabname=>'ESFC_TEST_T');

set autotrace traceonly statistics explain
set timing on 
set feedback on 
set lines 200


alter table esfc_test_t storage(cell_flash_cache default);

alter session set tracefile_identifier=keep_test;
exec dbms_session.session_trace_enable ( waits=>TRUE, binds=> FALSE ); 

alter system flush buffer_cache;
SELECT e, count(*) from esfc_test_t esfc_dflt_1  where a='A' GROUP BY e;

alter system flush buffer_cache;
SELECT e, count(*) from esfc_test_t  esfc_dflt_2  where a='A' GROUP BY e;

alter table esfc_test_t storage(cell_flash_cache keep);

alter system flush buffer_cache;
SELECT e, count(*) from esfc_test_t esfc_keep_1  where a='A' GROUP BY e;

alter system flush buffer_cache;
SELECT e, count(*) from esfc_test_t esfc_keep_2  where a='A' GROUP BY e;

exit;
