Anand Blogspot
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment