Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 11 2012
Added on Jun 13 2012
0 comments
724 views