Search This Blog

Total Pageviews

Friday, 9 September 2011

ORA-13605: THE SPECIFIED TASK OR OBJECT SYS_AUTO_SQL_TUNING_TASK DOES NOT EXIST

ORA-13605: THE SPECIFIED TASK OR OBJECT SYS_AUTO_SQL_TUNING_TASK DOES NOT EXIST



Solution
run the $ORACLE_HOME/rdbms/admin/execsqlt.sql script



SQL> @$ORACLE_HOME/rdbms/admin/execsqlt.sql

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

3 comments:

Marty said...

Solved my problem thank you very much!

idesdemars said...

It worked for me too. Had no idea how it was dropped in the first place.

Jack Almond said...

Nice Solution .. but i had different scenario of not getting SQL statement in repository itself .. this solution help ..

http://www.moreajays.com/2020/07/ora-13605-specified-task-or-object-does.html

Oracle DBA

anuj blog Archive