drop a sql profile - Oracle Database Script. BEGIN DBMS_SQLTUNE.drop_sql_profile (name => '&sql_profile', IGNORE => TRUE); END; / You can GET the respective sql_profile OF a sql_id FROM below: SELECT DISTINCT p.name sql_profile_name, s.sql_id FROM dba_sql_profiles p, DBA_HIST_SQLSTAT s WHERE p.name=s.sql_profile AND s.sql_id='&sql_id';
BEGIN DBMS_SQLTUNE.drop_sql_profile (name => '&sql_profile', IGNORE => TRUE); END; / You can GET the respective sql_profile OF a sql_id FROM below: SELECT DISTINCT p.name sql_profile_name, s.sql_id FROM dba_sql_profiles p, DBA_HIST_SQLSTAT s WHERE p.name=s.sql_profile AND s.sql_id='&sql_id';