Hi,
i performed sql tuning advisor in OEM,it given one recommendation. But while implementing recommendation getting below error.
There was a problem creating the SQL Profile ORA-13786: missing SQL text of statement object "1"
for tuning task "SQL_TUNING_1275371360912" 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
i tried like below
Home->Advisor Central->SQL Advisors->SQL Tuning Advisor->to actvity->actions SQl tunung advisors->Go->submiit
then i twill give some recommendation ->click on implement button there error occuered
and how i can see sql script after recommendation implemented one .could u please help
] 
Blog
Search
Help
Members
Register
Login
Home
