CODE EXAMPLE FOR SQL

oracle flush Shared Pool

select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_Id='dmx08r6ayx800';

exec DBMS_SHARED_POOL.PURGE ('0000000693E4C268,2515443712','C');