Friday, April 30, 2010

Purge the CURSOR on shared pool

SQL> select sql_id,PLAN_HASH_VALUE,address,hash_value,LAST_LOAD_TIME from v$sqlarea where sql_id in ('bnu1qhzppkqw5');

SQL_ID PLAN_HASH_VALUE ADDRESS HASH_VALUE LAST_LOAD_TIME
--------------- --------------- ---------------- ---------- -------------------
bnu1qhzppkqw5 1923980546 C0000007EC93A170 3948501893 2010/04/25 14:36:53

SQL> exec sys.dbms_shared_pool.purge('C0000007EABE6B60.2390770330', 'C');


SQL> select sql_id,PLAN_HASH_VALUE,address,hash_value,LAST_LOAD_TIME from v$sqlarea where sql_id in ('bnu1qhzppkqw5');

SQL_ID PLAN_HASH_VALUE ADDRESS HASH_VALUE LAST_LOAD_TIME
--------------- --------------- ---------------- ---------- -------------------
bnu1qhzppkqw5 1923980546 C0000007EC93A170 3948501893 2010/04/25 18:26:01