Hi,
I am trying to flush a single statement out of shared pool, But i am still seeing it in v$SQLAREA can someone explain to me why is this behaviour. The db version is 11.1.0.7
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like '9bw30rtanspj1%';
ADDRESS HASH_VALUE
---------------- ----------
000000052F9ACCA8 1431066145
SQL> exec DBMS_SHARED_POOL.PURGE ('000000052F9ACCA8, 1431066145', 'C');
PL/SQL procedure successfully completed.
SQL> select inst_id,ADDRESS, HASH_VALUE from gV$SQLAREA where SQL_ID like '9bw30rtanspj1%';
INST_ID ADDRESS HASH_VALUE
---------- ---------------- ----------
2 000000054F41B5C8 1431066145
1 000000052F9ACCA8 1431066145