Attempting to Implement a SQL Profile for Parallel Execution With the Validate SPA Button Within OEM12c Cloud Control Fails With: ORA-13786
(Doc ID 2173811.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
- Implementing a parallel SQL Profile with the Validate SPA command button returns:
CHAIN_LOG_ID="255788", STEP_NAME="S2", ORA-13786: missing SQL text of statement object "2" for tuning task "SQL_TUNING_1464024055494" ORA-06512: at line 25
- Stack Trace shows OEM12c Cloud Control passing the following code to the database to implement the profile:
BEGIN :1 := dbms_sqltune.accept_sql_profile(task_name => :2 , object_id => :3 , task_owner => :4 ); END;
- The Job Details within OEM12c Cloud shows:
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