Running Dbms_Sqltune.Pack_Stgtab_Sqlprof Throws Ora-600 [Kokbcollterminate] Error (Doc ID 461890.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

When executing dbms_sqltune.pack_stgtab_sqlprof procedure the following error is reported by Oracle:


ERROR at line 1:
SQL> exec DBMS_SQLTUNE.PACK_STGTAB_SQLPROF ( profile_name => '%', -
> profile_category => 'DEFAULT', -
> staging_table_name => 'SQL_PROFILES_TAB', -
> staging_schema_owner => 'MAC');

ORA-29400: data cartridge error
ORA-00600: internal error code, arguments: [kokbCollTerminate], [14], [], [],
[], [], [], []
ORA-06512: at "SYS.DBMS_SQLTUNE", line 4304
ORA-06512: at line 1

The last function on the stack is kokbCollTerminate

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