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).
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).
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
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