Disabling SQL profile
SQL> connect /as sysdba
Connected.
SQL> EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE('sql_profile_name','STATUS','DISABLED');
PL/SQL procedure successfully completed.
Deleting SQL Profile
SQL> begin
2 dbms_sqltune.drop_sql_profile (
3 name => 'SYS_SQLPROF_014c3eab45fe0000',
4 ignore => true);
5 end;
6 /
PL/SQL procedure successfully completed.
SQL>
