There are times when a sql statement needs to be removed or flushed from memory.
This is how to snipe a statement
select inst_id, address, hash_value from gv$sqlarea where sql_id = '3vvrcvtw8g9x1';
Substitute the address and hash value returned from the query. Run this statement a few times in a row on the database node indicated from the query above..
exec dbms_shared_pool.purge('0000000559994508,2022156193','C',2);
If it is a standalone server database then just remove the C and 2.
exec dbms_shared_pool.purge('0000000559994508,2022156193');
This is how to snipe a statement
select inst_id, address, hash_value from gv$sqlarea where sql_id = '3vvrcvtw8g9x1';
| INST_ID | ADDRESS | HASH_VALUE |
| 2 | 0000000559994508 | 2022156193 |
Substitute the address and hash value returned from the query. Run this statement a few times in a row on the database node indicated from the query above..
exec dbms_shared_pool.purge('0000000559994508,2022156193','C',2);
If it is a standalone server database then just remove the C and 2.
exec dbms_shared_pool.purge('0000000559994508,2022156193');
Do you realize there's a 12 word phrase you can tell your crush... that will trigger deep feelings of love and impulsive attractiveness for you deep within his heart?
ReplyDeleteBecause hidden in these 12 words is a "secret signal" that fuels a man's impulse to love, worship and protect you with all his heart...
12 Words Will Fuel A Man's Desire Response
This impulse is so built-in to a man's brain that it will drive him to try harder than before to make your relationship the best part of both of your lives.
As a matter of fact, fueling this influential impulse is so binding to having the best ever relationship with your man that as soon as you send your man a "Secret Signal"...
...You'll immediately notice him expose his heart and soul to you in a way he's never expressed before and he'll perceive you as the only woman in the galaxy who has ever truly appealed to him.