ORA-600 [kghfrf1] in EBS Database or Schedule SQL Analyze
(Doc ID 2114653.1)
Last updated on FEBRUARY 16, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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:
ORA-00600: internal error code, arguments: [kghfrf1], [0x000000000], [], [], [], [], [], [], [], [], [], []
Incident details in: <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_70111/<instname>_j000_93155_i70111.trc
The trace file shows next characteristics:
----- Current SQL Statement for this session (sql_id=...) -----
/* SQL Analyze(605,1) */ SELECT * FROM <TABLE_NAME>
----- 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
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
| Symptoms |
| Cause |
| Solution |
| References |