Flush a Sql from shared pool
How to flush a Sql rrom shared pool 1. Get the address and hash_value of the sql_id: select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_Id='Fdx08r6ai732Dd'; ADDRESS HASH_VALUE ---------------------------------- ---------- 0000000593W2N264 2515443712 2. Now purge the sql statement exec DBMS_SHARED_POOL.PURGE (‘ADDRESS,HASH_VALUE’,’C’); exec DBMS_SHARED_POOL.PURGE ('0000000593W2N264,2515443712','C'); PL/SQL procedure successfully completed. select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_Id='Fdx08r6ai732Dd'; no rows selected Altenatively you can the the script provided by Carlos Sierra. flush_from_cursor.sql REM Flushes one cursor out of the shared pool. Works on 11g+ REM To create DBMS_SHARED_POOL, run the DBMSPOOL.SQL script. REM The PRVTPOOL.PLB script is automatically executed after DBMSPOOL.SQL runs. REM These scripts are not run by as part of standard database creation. SPO flush_cursor_&&sql_id..txt; PRO *** before flush *** SELECT i
