Enable and Disable the SQL Profiles in Oracle

 

Enable and Disable the SQL Profiles in Oracle

Check the present SQL Profiles present in Oracle Database.

SELECT NAME,STATUS,SQL_TEXT FROM DBA_SQL_PROFILES;

Name: Got from the first query which profile you want to enable or disable

Enable the SQL Profile in Oracle Database:

EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(name =>'name_value', attribute_name=>'STATUS', value=>'ENABLED');

Disable the SQL Profile in Oracle Database:

EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE(name =>'name_value', attribute_name=>'STATUS', value=>'DISABLED');

Drop the SQL Profile if not needed:

Exec dbms_sqltune.drop_sql_profile(name=>'profile_name_value');