Important Disclaimer

The experiences, views, and opinions expressed in this website are my own and does not reflect the views or opinions of my employer. The comments, views, and opinions expressed by visitors to this website are theirs solely and does not reflect mine.

Any resolutions to problems discussed in this website worked for my specific experience. It is the readers’ responsibility to perform sufficient testing to make sure the resolution works for their specific environment.

  1. #1 by PAUL on June 1, 2013 - 00:20

    Please I need your help , I try to do the next

    SQL> declare
    2 dato varchar2(30);
    3 begin
    4 dato := dbms_sqltune.accept_sql_profile(task_name =>’tarea_numero23′);
    5 end;
    6 /
    declare

    but always have the same error

    ERROR at line 1:
    ORA-13786: missing SQL text of statement object “1” for tuning task
    “tarea_numero23”
    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 4

    Please can you help me whit this error? I’m runing it al ORACLE 10g release 10.2.0.1.0 and I have the same problem al ORACLE 11g release 11.2.0.1.0

    • #2 by asnsliveYudh on February 27, 2014 - 09:53

      i think you forgot the sql_id
      4 dato := dbms_sqltune.accept_sql_profile(task_name =>’tarea_numero23′);

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: