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'); |