Error on Applying a recommended Execution Plan
Hi Friends
After upgrading my release from 10.2.0.1.0 to 11.2.0.3 Oracle finds a SQL consuming too much CPU and suggests me a new sql plan, but on applying the recommendation via SQL Advisor on EM I receive this error.
""There was a problem creating the SQL Profile ORA-13786: missing SQL text of statement object "1" for tuning task "SQL_TUNING_1333970636323" ORA-06512: at "SYS.DBMS_SYS_ERROR";,
line 95 ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL";, line 16442 ORA-06512: at "SYS.PRVT_SQLPROF_INFRA";, line 31 ORA-06512: at "SYS.DBMS_SQLTUNE";, line 7544 ORA-06512: at line 1""
I searched on forum archives but found some similar cases not finished yet. I found no log for this error os logs directories, but the EM was recreated a couple of times because we changed the host IP address but everything works well instead of this procedure of accepting the recommendation.
Do you guys have any tips?
Tks