Andrew Fraser DBA

SQL profile drop

If you have accepted a sql profile from a tuning advisor recommandation like:

execute dbms_sqltune.accept_sql_profile(task_name => 'TASK_239607', replace => TRUE);

Then the regression commands to back it out are like:

select name from dba_sql_profiles;
exec dbms_sqltune.drop_sql_profile('MYNAME')