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';