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 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

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"

 

Cause

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
Symptoms
Cause
Solution
References


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