How to remove a sql statement from instance memory

There are times when a sql statement needs to be removed or flushed from memory.

This is how to snipe a statement. Get the SQLID from OEM or the find SIQID from gv$sessions. Once you have the sql id use that to get the address id. 

select inst_id, address, hash_value from gv$sqlarea where sql_id = '3vvrcvtw8g9x1'; ​INST_ID ​ADDRESS ​HASH_VALUE ​2 ​ 0000000559994508  ​2022156193

Substitute the address and hash value returned from the query.  Run this statement a few times in a row on the database node indicated from the query above.

exec dbms_shared_pool.purge('0000000559994508,2022156193','C',2);