How To Load SQL Profile When You Get Error - ORA-13605: The specified task or object sqlt_s27435_awr does not exist for the current user

(Doc ID 1947035.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10.2 to 12.2.4 [Release 11.5 to 12.2]
Information in this document applies to any platform.

Goal

CUSTOMER REPORTS
---------------------------
SQL> connect / as sysdba
Connected.

SQL> @sqlt_s27435_sta_script_mem.sql
BEGIN dbms_sqltune.accept_sql_profile(task_name => 'sqlt_s27435_mem', replace => TRUE); END;

*
ERROR at line 1:
ORA-13605: The specified task or object sqlt_s27435_awr does not exist for the
current user.
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.PRVT_ADVISOR", line 5878
ORA-06512: at "SYS.PRVT_SQLPROF_INFRA", line 28
ORA-06512: at "SYS.DBMS_SQLTUNE", line 7544
ORA-06512: at "SYS.DBMS_SQLTUNE", line 7568
ORA-06512: at line 1



Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms