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;
/
删除sql profile绑定的执行计划
未经允许不得转载:徐万新之路 » 删除sql profile绑定的执行计划
相关推荐
Oracle 26ai: How to install Oracle 26ai GI (HAS) using Native ASM
Oracle 26ai RAC 图形界面安装指南(VirtualBox + OL 8.10)
Vmware Workstation 2026下Oracle Linux 8.10 虚拟机网卡命名对齐方案(ebsdb1 / ebsdb2)
sysaux中HEATMAP 对象较大
生产库AWR手工清理及 SYSAUX 表空间收缩
Oracle Data Guard 11g到19c切换避坑指南
Enabling Natural Language Query of EBS 12.2 Using Oracle Generative AI Now Available
查询v$asm_disk视图hang住

徐万新之路

