正德厚生,臻于至善

删除sql profile绑定的执行计划

select sql_id, address, hash_value, executions, loads, parse_calls, invalidations  
from v$sqlarea  where sql_id='1ubrfsjjn7016';

call sys.dbms_shared_pool.purge('07000116C8381C68,1665368102','c');

select name,created,category,sql_text from dba_sql_profiles where name like '%1ubrfsjjn7016%' order by created desc;

begin
DBMS_SQLTUNE.DROP_SQL_PROFILE(name => 'coe_1ubrfsjjn7016_3135409287');
end;
/
赞(0) 打赏
未经允许不得转载:徐万新之路 » 删除sql profile绑定的执行计划

评论 抢沙发

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫

微信扫一扫

登录

找回密码

注册