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 ?