Skip to content

Basic operations related to SQL Profile

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]

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

Be First to Comment

Leave a Reply

Required fields are marked *

error: Alert: Content is protected !!