Purge bad sql plan from memory

Find the Address and hash_value.

SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like ‘7yc%’;

ADDRESS HASH_VALUE
—————- ———-
000000085EF77CF0  808321006

SQL> exec DBMS_SHARED_POOL.PURGE (‘000000085EF77CF0, 808321006’, ‘C’);

PL/SQL procedure successfully completed.

SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like ‘7yc%’;

no rows selected

  • December 28, 2015 | 17 views