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

 

Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (10 votes, average: 5.00 out of 5)
Loading...

Add Comment