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: 105]
You can connect with me on LinkedIn.
Latest posts by Brijesh Gogia (see all)
- Performance Tuning Basics 16 : Using SQL Tuning Health-Check Script (SQLHC) - April 1, 2018
- Physical and Logical Block Corruption in Oracle Database - March 10, 2018
- Performance Tuning Basics 15 : AWR Report Analysis - February 6, 2018