–查看绑定的sql profile
select * from dba_sql_profiles;
–删除上面绑定执行计划
begin
DBMS_SQLTUNE.DROP_SQL_PROFILE(name => ‘coe_1g1k2rcasn516_3203434082’);
end;
/
SQL优化篇--删除sql profile绑定的执行计划
最新推荐文章于 2021-08-26 09:33:47 发布
–查看绑定的sql profile
select * from dba_sql_profiles;
–删除上面绑定执行计划
begin
DBMS_SQLTUNE.DROP_SQL_PROFILE(name => ‘coe_1g1k2rcasn516_3203434082’);
end;
/