My Oracle Support Banner

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 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

Database Error:
"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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.