Todays let ‘s have look at the query which we use to resolve this issue ” How to Flush Single SQL Plan out of Shared Pool”. 



Find the address and the hash value

SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID='495fdyn7cd34r';


---------------- ----------

00000005ODJD9BC0 247122679

Execute the purge procedure

SQL> exec DBMS_SHARED_POOL.PURGE ('00000005ODJD9BC0,247122679','C');

PL/SQL procedure successfully completed.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.