set echo on;
select version from v$instance;
create table xxtest as select level id from dual connect by level<=1e3;
call dbms_stats.gather_table_stats(user,'xxtest');
select * from xxtest where id = 4;
select * from xxtest where id = 4;
select * from xxtest where id = 4;
select * from xxtest where id = 4;
select * from xxtest where id = 4;
select sql_id,s.executions, s.loads, s.invalidations from v$sql s where sql_text like 'select * from xxtest where id = 4%';
comment on table xxtest is 'xxtest';
select * from xxtest where id = 4;
select sql_id,s.executions, s.loads, s.invalidations from v$sql s where sql_text like 'select * from xxtest where id = 4%';
set echo off;

SQL> select version from v$instance;

VERSION
-----------------
19.0.0.0.0
SQL> create table xxtest as select level id from dual connect by level<=1e3;
SQL> call dbms_stats.gather_table_stats(user,'xxtest');
SQL> select * from xxtest where id = 4;

        ID
----------
         4
SQL> select * from xxtest where id = 4;

        ID
----------
         4
SQL> select * from xxtest where id = 4;

        ID
----------
         4
SQL> select * from xxtest where id = 4;

        ID
----------
         4
SQL> select * from xxtest where id = 4;

        ID
----------
         4
SQL> select sql_id,s.executions, s.loads, s.invalidations from v$sql s where sql_text like 'select * from xxtest where id = 4%';

SQL_ID        EXECUTIONS      LOADS INVALIDATIONS
------------- ---------- ---------- -------------
1905x4g80dfjp          5          1             0
SQL> comment on table xxtest is 'xxtest';
SQL> select * from xxtest where id = 4;

        ID
----------
         4
SQL> select sql_id,s.executions, s.loads, s.invalidations from v$sql s where sql_text like 'select * from xxtest where id = 4%';

SQL_ID        EXECUTIONS      LOADS INVALIDATIONS
------------- ---------- ---------- -------------
1905x4g80dfjp          6          1             0