How to Flush Single SQL Plan out of Shared Pool
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID='495ntyn7cd29r';
ADDRESS HASH_VALUE
---------------- ----------
00000005CEBD9BC0 247892279
SQL> exec DBMS_SHARED_POOL.PURGE ('00000005CEBD9BC0,247892279','C');
PL/SQL procedure successfully completed.
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID='495ntyn7cd29r';
no rows selected