Enabling/Disabling/Deleting a SQL Profile

Submitted by dmann on Thu, 05/07/2009 - 15:56

Viewing

Profile Summary

SELECT * FROM DBA_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: 
EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE('PROFILE_NAME','STATUS','DISABLED');

Dropping a SQL Profile

EXEC DBMS_SQLTUNE.DROP_SQL_PROFILE('PROFILE_NAME');