Flush shared_pool with dbms_shared_pool.purge no working
Hello, i have a question/problem, recently i need to age out from shared_pool one sql statement, i read about dbms_shared_pool.purge and tried it on test environment, it worked.
But when i try to do same thing on production db, its do nothing:
list of sqlarea with high versions:
SQL_ID MB_USED ADDRESS HASH_VALUE EXECUTIONS LOADS VERSION_COUNT LOADED_VERSIONS OPEN_VERSIONS INVALIDATIONS PARSE_CALLS
------------- ---------- ---------------- ---------- ---------- ---------- ------------- --------------- ------------- ------------- -----------
93mfpb7a8fa20 203.813298 0000000223EEC2F0 3565627456 266 268 268 266 0 2 267
trying to purge:
SQL> exec dbms_shared_pool.purge ('0000000223EEC2F0, 3565627456','C');
0