Hi
I am facing an issue while implementing sql profile through enterprise management console. I am getting below mentioned error :
*****************************************************************************
There was a problem creating the SQL Profile ORA-13786: missing SQL text of statement object "3" for tuning task "SQL_TUNING_1376379948963" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 16255 ORA-06512: at "SYS.PRVT_SQLPROF_INFRA", line 31 ORA-06512: at "SYS.DBMS_SQLTUNE", line 7133 ORA-06512: at line 1
*********************************************************************************
In my environment i am using oracle version : 11.2.0.1 and o/s is AIX.
I have created a sql tuning set containing awr snapshot for last 24 hours and will contain top 15 sql statements based on estimated_time. I also scheduled sql tuning advisor using the same sql tuning set that i had created and found few sql profiles that were beneficial. When i tried to implement the same, i am getting the above mentioned error. I have also tried to implement sql profile one by one but getting the same error.
Please suggest how can i implement it.