Oracle : How to Purge CURSORS related to a single SQL_ID from library cache

*********************************************************************

How to Purge CURSORS related to a single SQL_ID from library cache

*********************************************************************

SQL> select ADDRESS, HASH_VALUE from V$SQL where SQL_ID like ‘8zdchyshg4d3g’;

select ADDRESS, HASH_VALUE,plan_hash_value from V$SQL where SQL_ID like ‘8zdchyshg4d3g’;

SQL> exec DBMS_SHARED_POOL.PURGE (‘000000180DC67320,552744047′,’C’);

PL/SQL procedure successfully completed.

 SQL> select ADDRESS, HASH_VALUE from V$SQL where SQL_ID like ‘8zdchyshg4d3g’;

no rows selected

 SQL> select ADDRESS, HASH_VALUE,plan_hash_value from V$SQL where SQL_ID like ‘8zdchyshg4d3g’;

no rows selected