Home » RDBMS Server » Performance Tuning » DBMS_AUTO_SQLTUNE (CentOS 6.2 64-bit, Oracle11gR2
DBMS_AUTO_SQLTUNE [message #570129] Mon, 05 November 2012 15:30 Go to next message
Messages: 6
Registered: August 2012
Location: San Diego California
Junior Member
DBMS_AUTO_SQLTUNE was introduced in 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?

David R.

Re: DBMS_AUTO_SQLTUNE [message #570131 is a reply to message #570129] Mon, 05 November 2012 17:14 Go to previous messageGo to next message
Messages: 25581
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:


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?
Re: DBMS_AUTO_SQLTUNE [message #570152 is a reply to message #570129] Mon, 05 November 2012 23:54 Go to previous message
Michel Cadot
Messages: 65155
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.

Previous Topic: Different SQL ID for same SQL/HASH_VALUE
Next Topic: TKprof generation for short duration
Goto Forum:

Current Time: Wed Aug 23 18:26:03 CDT 2017

Total time taken to generate the page: 0.01339 seconds