📋Steps in this guide1/1

Flush a sql query from cursor

First get the address, hash_value of the sql_id

oracle configurationintermediate

by OracleDba

12 views

Flush a sql query from cursor

First get the address, hash_value of the sql_id Now flush the query

Code/Command (click line numbers to comment):

select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like '5qd8a442c328k';
ADDRESS          HASH_VALUE
---------------  ------------
C000007067F39FF0  4000666812
SQL> exec DBMS_SHARED_POOL.PURGE ('C000007067F39FF0, 4000666812', 'C');
Note : For RAC, same need to be executed on all the nodes .

Comments (0)

Please to add comments

No comments yet. Be the first to comment!