📋Steps in this guide1/1

How To Flush A Sql Statement From Shared Pool

If you flush the shared pool, all the statements in cursor will be flushed. So if you want a sql query to do hard parsing, then you can flush the particular

oracle configurationintermediate

by OracleDba

13 views

Overview

If you flush the shared pool, all the statements in cursor will be flushed. So if you want a sql query to do hard parsing, then you can flush the particular sql statement from shared pool. Follow the below steps :

Code/Command (click line numbers to comment):

select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_Id='dmx08r6ayx800';


ADDRESS HASH_VALUE
---------------------------------- ----------
0000000693E4C268 2515443712

exec DBMS_SHARED_POOL.PURGE (‘ADDRESS,HASH_VALUE’,’C’);

exec DBMS_SHARED_POOL.PURGE ('0000000693E4C268,2515443712','C'); 
PL/SQL procedure successfully completed.

select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_Id='dmx08r6ayx800';  

no rows selected

Comments (0)

Please to add comments

No comments yet. Be the first to comment!