Enabling/Disabling/Deleting a SQL Profile

CDB and PDB Scope

It looks like PDBs and CDBs can own SQL Profiles. Use DBA_SQL_PROFILES view in a PDB and CDB_SQL_PROFILES view in the CDB to review SQL profiles.

If you log into the CDB with Cloud Control then it looks like all profile work will be done on the CDB level. Just be aware of this - if you create a SQL Profile in a PDB manually using a script like coe_xfr_sql_profile.sql, you may not be able to administrate it with the Cloud Control GUI.

Viewing

Profile Summary

-- Traditional DB or PDB
SELECT * FROM DBA_SQL_PROFILES;

-- Container database, note the CON_ID will show which DB the profiles are owned by
SELECT * FROM CDB_SQL_PROFILES;

Profile Attribute Detail

SELECT *
  FROM DBA_SQL_PROFILES prof, 
       DBMSHSXP_SQL_PROFILE_ATTR attr
  WHERE prof.NAME=attr.PROFILE_NAME
  ORDER BY prof.name,
           attr.attr_number;

Enable/Disable

Locate the name of the SQL Profile you would like to disable and plug it in to the following statement:
-- Enable an existing profile:
EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE('PROFILE_NAME','STATUS','DISABLED');

-- Disabling an existing profile:
EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE('PROFILE_NAME','STATUS','DISABLED');

Dropping a SQL Profile

EXEC DBMS_SQLTUNE.DROP_SQL_PROFILE('PROFILE_NAME');