Implementation Of Recommended SQL Parallel Profile (by SQL Tuning Advisor) Fails With ORA-13786
(Doc ID 2883409.1)
Last updated on SEPTEMBER 20, 2022
Applies to:Enterprise Manager for Oracle Database - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
In Enterprises Manager (EM) Cloud Control, while implementing SQL tuning advisor recommended SQL parallel profile, it fails with ORA-13786
"There was a problem creating the SQL Profile ORA-13786: missing SQL text of statement object "2" for tuning task "SQL_TUNING_1651041797452"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 18610
ORA-06512: at "SYS.PRVT_SQLPROF_INFRA", line 24
ORA-06512: at "SYS.DBMS_SQLTUNE", line 10883
ORA-06512: at line 1"
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