Friday, September 8, 2017

Flush specific sql from shared pool

select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like 'cj15zn2ydvac4';

exec DBMS_SHARED_POOL.PURGE ('000000085FD77CF0, 808321886', 'C');

To flush complete shared pool ofcourse:

alter system flush share_pool;


No comments:

Post a Comment