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');