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: 118]
You can connect with me on LinkedIn.
Latest posts by Brijesh Gogia (see all)
- Oracle Cloud Infrastructure (OCI) – 3 – Concept of Compartments - January 22, 2019
- Oracle Cloud Infrastructure (OCI) – 2 – Console - January 21, 2019
- Oracle Cloud Infrastructure (OCI) – 1 – Fundamentals - January 21, 2019