Home » RDBMS Server » Enterprise Manager » implement OEM error (11g oracle)
implement OEM error [message #458827] Wed, 02 June 2010 01:33
Messages: 36
Registered: May 2007
Location: bangalore

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
Previous Topic: OEM installation in Linux
Next Topic: dbconsole doesnot start after fresh installation
Goto Forum:

Current Time: Mon Dec 06 11:02:51 CST 2021