ORA-600 [kghfrf1] in EBS Database or Schedule SQL Analyze

(Doc ID 2114653.1)

Last updated on OCTOBER 25, 2017

Applies to:

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

Symptoms

An automatic SQL Analyze scheduled via DBMS_SCHEDULER fails with error like below in the alert log:

Errors in file /u01/app/oracle/diag/rdbms/appsdb/appsdb1/trace/appsdb1_j000_93155.trc (incident=70111):
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/diag/rdbms/appsdb/appsdb1/incident/incdir_70111/appsdb1_j000_93155_i70111.trc


The trace file shows next characteristics:

----- Current SQL Statement for this session (sql_id=...) -----

/* SQL Analyze(605,1) */ SELECT CONCAT ( CONCAT(CAST(INFO.VM_ID AS NVARCHAR2(24)), N':'), INFO.NAME ) AS FILE_KEY, INFO.VM_ID, INFO.NAME FROM VPX_VM_FLE_FILE_INFO INFO, VPX_VM_FLE_DISK_UNIT DU, VPX_INT_ARRAY IA, ( SELECT DL.VM_ID, DL.KEY_VAL FROM VPX_VM_FLE_DISK_LAYOUT DL LEFT OUTER JOIN ( SELECT DI...


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

Problem Key: ORA 600 [kghfrf1]
Error: ORA-600 [kghfrf1] [0x000000000] [] [] [] [] [] [] [] [] [] []
[00]: dbgeEndDDEInvocationImpl [diag_dde]
[01]: kghnerror [KGH]<-- Signaling
[02]: kghfrf [KGH]
[03]: qsmmstsStarFree []
[04]: qsmmstsCollectQueryStatsOfAQbc []
[05]: qsmmstsTraverseQbc []
[06]: qsmmstsTraverseQbc []
[07]: qsmmstsCollectQueryStats []
[08]: apadrv [SQL_APA]
[09]: opitca [OPI]
[10]: kksFullTypeCheck [cursor]
[11]: rpiswu2 [RPI]
[12]: kksSetBindType [cursor]
[13]: kksfbc [cursor]
[14]: opiexe [Time_Limit]
[15]: kpoal8 [PROGINT_MISC]
[16]: opiodr [OPI]
[17]: kpoodrc [PROGINT_MISC]
[18]: rpiswu2 [RPI]
[19]: kpoodr [PROGINT_MISC]
[20]: upirtrc []
[21]: kpurcsc [PROGINT]
[22]: kpuexec [PROGINT]
[23]: OCIStmtExecute []
[24]: qksanExecSql [SQL_Analyze]
[25]: qksanAnalyzeSqlConCbk [SQL_Analyze]
[26]: qksanAnalyzeSql [SQL_Analyze]
[27]: qsmmstsGatherColumnCount []
[28]: qsmmwrkFetchWorkload []
[29]: qsmmcdPPFetchWorkload []
[30]: qsmmcdMainPPInit []
[31]: qsmmcdMainPP []
[32]: qsmmcdMain []
[33]: spefcmpa []
[34]: spefmccallstd []
[35]: peftrusted [PLSQL_External_Proc]
[36]: psdexsp [PROGINT_PLSQL]
[37]: rpiswu2 [RPI]
[38]: kxe_push_env_internal_pp_ [SQL_Execution]
[39]: kkx_push_env_for_ICD_for_new_session [PROGINT_PLSQL]
[40]: psdextp [PROGINT_PLSQL]
[41]: pefccal [PLSQL_External_Proc]
[42]: pefcal [PLSQL_External_Proc]
[43]: pevm_FCAL [PLSQL_Code_Execution]
[44]: pfrinstr_FCAL [PLSQL_Code_Execution]
[45]: pfrrun_no_tool [PLSQL_Code_Execution]

 

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