ORA-600 [keshs_drop-1] While Dropping SQL_PROFILE (Doc ID 2051502.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Alert log reports error as below:

...
Errors in file /u01/app/oracle/diag/rdbms/sbl/SBL2/trace/SBL2_ora_23137.trc  (incident=79459):
ORA-00600: internal error code, arguments: [keshs_drop-1], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/sbl/SBL2/incident/incdir_79459/SBL2_ora_23137_i79459.trc
...


The trace file shows characteristics like:

----- Current SQL Statement for this session (sql_id=0drs5hzb06s5n) -----
BEGIN dbms_sqltune.drop_sql_profile(name => :1 , ignore => TRUE); END;

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0xb96b16ad8     16453  package body SYS.DBMS_SQLTUNE_INTERNAL
0xb6bea57f8        55  package body SYS.PRVT_SQLPROF_INFRA
0xb7f9bea30      7587  package body SYS.DBMS_SQLTUNE
0xb965b66b0         1  anonymous block

----- Call Stack Trace -----

... keshs_drop keshs_dropExt spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ...

 

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