Flush a Single SQL statement from the Shared Pool
-- Flush a single SQL statement for the shared pool
select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID='dgg63prq0s376'
;

ADDRESS          HASH_VALUE
---------------- ----------
00000006730D9E40 3960212710

-- Use values for this proc:
exec DBMS_SHARED_POOL.PURGE ('00000006730D9E40, 3960212710', 'C');