Database Administration (MOSC)

MOSC Banner

Cannot flush a sql_id in 19c

Hi,

I've been trying to get rid of a sql_id from the shared pool but no matter what I try it comes back.

select address, hash_value from V$SQLAREA where SQL_ID = '8rj40f241338f';

exec DBMS_SHARED_POOL.PURGE ('00000000D8619B48, 2282851598', 'C');

Even if I flush the shared pool, it comes back:

ALTER SYSTEM FLUSH SHARED_POOL;

There are many user connections that potentially call the procedure where the query is. I've modified the query to better use an index. I've killed all the sessions that were stuck on that sql_id and I've successfully compiled the package, but the sql_id 8rj40f241338f is still picked. How to permanently remove that sql_id so that the new execution plan can be chosen?

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