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

Comments