How to Disable and Drop SQL Profiles in Oracle

Check the SQL Profile is used for the particular SQL ID

select SQL_ID, SQL_PROFILE,PLAN_HASH_VALUE from V$SQL where SQL_ID='2pakcawx9beyz';

Disable the SQL Profile:

EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(Name => '<SQL PROFILE>', Attribute_Name => 'STATUS', Value => 'DISABLED');

Drop the SQL Profile:

EXEC DBMS_SQLTUNE.DROP_SQL_PROFILE(Name => '<SQL PROFILE>');