OraFAQ Forum: Performance Tuning » DBMS_AUTO

Home » RDBMS Server » Performance Tuning » DBMS_AUTO_SQLTUNE (CentOS 6.2 64-bit, Oracle11gR2 11.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DBMS_AUTO_SQLTUNE [message #570129]

Mon, 05 November 2012 15:30

debrucer2
Messages: 6
Registered: August 2012
Location: San Diego California

Junior Member

DBMS_AUTO_SQLTUNE was introduced in 11.2.0.2.0 and an interface for DBMS_SQLTUNE. We are on 64-bit Linux version 6.2.

SQLTUNE is working when manually executed; but, the AUTO is not. It fails with the following error stack:

Sun Nov 04 14:03:25 2012
Errors in file /u01/app/oracle/diag/rdbms/ritws/ritws/trace/ritws_j002_3438.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SQ_SQL_SW_1428"
ORA-13605: The specified task or object SYS_AUTO_SQL_TUNING_TASK does not exist for the current user.
ORA-06512: at "SYS.PRVT_ADVISOR", line 2735
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 821
ORA-06512: at line 4

There are no broken objects. I have rerun "$ORACLE_HOME/rdbms/admin/dbmssqlt.sql" which completed with no errors; however, no change.

Short of opening an SR with MOS, does anyone have any suggestions?

Thanks,
David R.

Report message to a moderator

Re: DBMS_AUTO_SQLTUNE [message #570131 is a reply to message #570129]

Mon, 05 November 2012 17:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

yes, you have a nice error, but we have no idea what exactly was done to produce it.
How can we reproduce what you report?

Report message to a moderator

Re: DBMS_AUTO_SQLTUNE [message #570152 is a reply to message #570129]

Mon, 05 November 2012 23:54

Michel Cadot
Messages: 68501
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ORA-13605: The specified task or object %s does not exist for the current user.
 *Cause:  The user attempted to reference an advisor task or object
          using a name that does not exist in the Advisor repository.
 *Action: Adjust the name and retry the operation.

Regards
Michel

Report message to a moderator

Re: DBMS_AUTO_SQLTUNE [message #681291 is a reply to message #570129]

Sat, 04 July 2020 04:09

Jack Almond
Messages: 1
Registered: July 2020

Junior Member

i had similar error..this error occurred not because the task doesn't exist but the tuning task itself was not created .. this link helped to solve ora-13605 error

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

Report message to a moderator

Previous Topic:	Find Locking History
Next Topic:	New to tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 05:44:25 CDT 2023