Database Tuning (MOSC)

MOSC Banner

Flush shared_pool with dbms_shared_pool.purge no working

edited Nov 15, 2011 5:15PM in Database Tuning (MOSC) 6 commentsAnswered
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');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center