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 JANUARY 23, 2023
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |