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绑定的执行计划