Contact

If you wish to contact me then please feel free to email me at:

kerrirobberts@gmail.com

However, please be aware that I won’t reply until after5.30pm (GMT).

  1. January 15, 2013 at 10:15 PM

    I enjoyed reading you blog: Oracle – Optimizer stats not being purged which I found very helpful and easy to follow. I would like to invite you to use our database navigation tool at no cost. Which I am convinced will provide great help in you daily job as an Oracle dba, for fast Oracle database navigation, swift investigation and resolution.
    http://www.idbasolutions.com/en/free-version.html

  2. PAUL
    June 1, 2013 at 1:33 AM

    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

  1. March 26, 2023 at 8:30 AM

Leave a comment