DECLARE
  name varchar2(50);
  version varchar2(3);
BEGIN
  select regexp_replace(version,'\..*') into version from v$instance;

  if version = '10' then
    execute immediate 
      q'[alter session set events '5614566 trace name context forever']'; -- bug fix for 10.2.0.4 backport
  end if;

  select address||','||hash_value into name
  from v$sqlarea 
  where sql_id like '&sql_id';

  sys.dbms_shared_pool.purge(name,'C',1);

END;
/

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