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>

1 comment:

  1. What's up Dear, are you truly visiting this web site on a regular
    basis, if so after that you will absolutely take nice know-how.



    Here is my homepage :: www.facebook.com/vitacost.coupons/app_170104573041662

    ReplyDelete