ORA-13786 on dbms_sqltune.accept_sql_profile
When i run parallel profile in sql plus/EM i am getting the following error on 11202.
SQL> exec dbms_sqltune.accept_sql_profile(task_name => 'SQL_TUNING_1339583991630', object_id => '1', task_owner => 'SYS', profile_type=>dbms_sqltune.PX_PROFILE);
BEGIN dbms_sqltune.accept_sql_profile(task_name => 'SQL_TUNING_1339583991630', object_id => '1', task_owner => 'SYS', profile_type=>dbms_sqltune.PX_PROFILE); END;
*
ERROR at line 1:
ORA-13786: missing SQL text of statement object "1" for tuning task
"SQL_TUNING_1339583991630"
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 "SYS.DBMS_SQLTUNE", line 7568
ORA-06512: at line 1
is there any known issue or am i need to file a new bug 5/rdbms/SVRMAN SQLTN ?
Could you comment on this. If known issue please share the bug number
Thanks
Appusamy Murugan