Receiving ORA-13787 Or ORA-13830 When Accepting SQL Profile With 'force_match' Option Set To TRUE (Doc ID 1067741.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Enterprise Manager for RDBMS - Version: 10.2.0.1 to 11.1.0.6 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

Accepting a SQL Profile (using DBMS_SQLTUNE.ACCEPT_SQL_PROFILE procedure) with FORCE_MATCH option set to TRUE may fail with any of the following errors:

ORA-13830: SQL profile with category DEFAULT already exists for this SQL statement
ORA-6512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 11054
ORA-6512: at "SYS.PRVT_SQLPROF_INFRA", line 30
ORA-6512: at "SYS.DBMS_SQLTUNE", line 5672
ORA-6512: at line 1"

or

ORA-13787: missing SQL profile for statement object "2" for tuning task "Anand_STA2" ORA-6512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 11054
ORA-6512: at "SYS.PRVT_SQLPROF_INFRA", line 30
ORA-6512: at "SYS.DBMS_SQLTUNE", line 5672
ORA-6512: at line 1

DBA_SQL_PROFILES view shows that there is no such currently existing SQL Profile.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms