Home » RDBMS Server » Performance Tuning » DBMS_AUTO_SQLTUNE (CentOS 6.2 64-bit, Oracle11gR2 11.2.0.3.0)
DBMS_AUTO_SQLTUNE [message #570129] Mon, 05 November 2012 15:30 Go to next message
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.

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
BlackSwan
Messages: 22515
Registered: January 2009
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?
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: 58605
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
Previous Topic: Table rebuild should be done after removing most of its data?
Next Topic: Long running query
Goto Forum:
  


Current Time: Mon Jul 28 17:38:30 CDT 2014

Total time taken to generate the page: 0.12739 seconds