How to find the ADDRESS, HASH_VALUE from V$SQLAREA for a query to purge ?
cayenneAug 15 2012 — edited Aug 15 2012I'm reading on how to use the DBMS_SHARED_POOL package to remove a query from the shared pool.
I"m looking at the example given on this page:
https://blogs.oracle.com/mandalika/entry/oracle_rdbms_flushing_a_single
It gives an example of:
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like '7yc%';
ADDRESS HASH_VALUE
---------------- ----------
000000085FD77CF0 808321886
My question is...how did they find the SQL_ID of the query they're wanting to purge before this step?
Thanks in advance,
cayenne