TO ACCPET A SQL PROFILE
SQL> execute dbms_sqltune.accept_sql_profile(task_name => ‘TASK_96’,replace => TRUE);
If you want the profile to be registered with a custom name use,
SQL> execute dbms_sqltune.accept_sql_profile(task_name => ‘TASK_96’,name => ‘CUSTOM_PROF_Query1’);
TO DISABLE SQL PROFILE
SQL> connect /as sysdba Connected. SQL> EXEC DBMS_SQLTUNE.ALTER_SQL_PROFILE('sql_profile_name','STATUS','DISABLED'); PL/SQL procedure successfully completed.
TO DELETE SQL PROFILE
begin dbms_sqltune.drop_sql_profile ( name => 'SYS_SQLPROF_014c3eab45fe0000', ignore => true); end; /
HAS SQL USED THE PROFILE?
Look at OUTLINE_CATEGORY and SQL_PROFILE columns. NULL indicates that no Outline/Profile was used.
[Post Views: 82]
You can connect with me on LinkedIn.
Latest posts by Brijesh Gogia (see all)
- SYSADMIN login performance issue in Oracle EBS R12 - January 4, 2018
- Important Commands related to Transparent Data Encryption (TDE) - December 21, 2017
- Oracle EBS R12 and TDE Tablespace Encryption - December 21, 2017