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