Sunday, January 29, 2012

Disabling / deleting SQL Profile


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>

No comments:

Post a Comment