SQL Performance (MOSC)

MOSC Banner

SQL Profile not getting accepted

Hi All,

Our env is EBS 12.1.3 with database 19c on RHEL 8.5.

I am running sql tuning task on an SQL statement and it is giving this recommendation:

 - Consider accepting the recommended SQL profile. A SQL plan baseline                                                 

  corresponding to the plan with the SQL profile will also be created.                                                 

  execute dbms_sqltune.accept_sql_profile(task_name =>                                                         

      'fr4rpnu3f8vp2_sql_tuning_task', task_owner => 'APPS', replace                                               

      => TRUE);                                                                          

I have accepted the profile as follows:

begin

dbms_sqltune.accept_sql_profile(task_name =>'fr4rpnu3f8vp2_sql_tuning_task', task_owner => 'APPS', replace =>TRUE);

end;

/   

But when I run the tuning task again, it is giving me the same recommendation. Am I missing something here ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center