ORA-600 [kghfrempty:ds] And ORA-600 [kghrcdepth:ds] While Gathering Statistics
(Doc ID 1480132.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.2.0.0. to 11.2.0.2.0 [Release 11.2]
Oracle 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
Information in this document applies to any platform.
Symptoms
ORA-600 [kghfrempty:ds] followed by ORA-600 [kghrcdepth:ds] can be seen while gathering stats.
Alert.log:
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_j005_27256.trc (incident=245244):
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF78DE0038], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_245244/<instname>_j005_27256_i245244.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_j005_27256.trc (incident=245245):
ORA-00600: internal error code, arguments: [kghrcdepth:ds], [0xFFFFFFFF78DE0038], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF78DE0038], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms<dbname>/<instname>/incident/incdir_245245/<instname>_j005_27256_i245245.trc
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF78DE0038], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms/<dbname>/<instname>/incident/incdir_245244/<instname>_j005_27256_i245244.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file <diagnostic_dest>/diag/rdbms/<dbname>/<instname>/trace/<instname>_j005_27256.trc (incident=245245):
ORA-00600: internal error code, arguments: [kghrcdepth:ds], [0xFFFFFFFF78DE0038], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF78DE0038], [], [], [], [], [], [], [], [], [], []
Incident details in:<diagnostic_dest>/diag/rdbms<dbname>/<instname>/incident/incdir_245245/<instname>_j005_27256_i245245.trc
Incident file:
----- Current SQL Statement for this session (sql_id=6rnkfr5166hpt) -----
/* SQL Analyze(1) */ select /*+ full(t) parallel(t,2) parallel_index(t,2) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("<column1>")),to_char(substrb(dump(min("<column1>"),16,0,32),1,120)),to_char(substrb(dump(max("<column1>"),16,0,32),1,120)),to_char(count("<column2>")),to_char(substrb(dump(min("<column2>"),16,0,32),1,120)),
to_char(substrb(dump(max("<column2>"),16,0,32),1,120)),to_char(count("<column3>")),to_char(substrb(dump(min("<column3>"),16,0,32),1,120)),to_char(substrb(dump(max("<column3>"),16,0,32),1,120)),
to_char(count("<column4>")),to_char(substrb(dump(min("<column4>"),16,0,32),1,120)),to_char(substrb(dump(max("<column4>"),16,0,32),1,120)),t
----- PL/SQL Call Stack -----
object line object
handle number name
585919c58 145 package body SYS.DBMS_SQLTUNE_INTERNAL
585919c58 12085 package body SYS.DBMS_SQLTUNE_INTERNAL
585919c58 12719 package body SYS.DBMS_SQLTUNE_INTERNAL
585919c58 17400 package body SYS.DBMS_SQLTUNE_INTERNAL
551041008 6764 package body SYS.DBMS_STATS_INTERNAL
582933cc0 20153 package body SYS.DBMS_STATS
582933cc0 21081 package body SYS.DBMS_STATS
582933cc0 22271 package body SYS.DBMS_STATS
582933cc0 22974 package body SYS.DBMS_STATS
582933cc0 29553 package body SYS.DBMS_STATS
/* SQL Analyze(1) */ select /*+ full(t) parallel(t,2) parallel_index(t,2) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad */to_char(count("<column1>")),to_char(substrb(dump(min("<column1>"),16,0,32),1,120)),to_char(substrb(dump(max("<column1>"),16,0,32),1,120)),to_char(count("<column2>")),to_char(substrb(dump(min("<column2>"),16,0,32),1,120)),
to_char(substrb(dump(max("<column2>"),16,0,32),1,120)),to_char(count("<column3>")),to_char(substrb(dump(min("<column3>"),16,0,32),1,120)),to_char(substrb(dump(max("<column3>"),16,0,32),1,120)),
to_char(count("<column4>")),to_char(substrb(dump(min("<column4>"),16,0,32),1,120)),to_char(substrb(dump(max("<column4>"),16,0,32),1,120)),t
----- PL/SQL Call Stack -----
object line object
handle number name
585919c58 145 package body SYS.DBMS_SQLTUNE_INTERNAL
585919c58 12085 package body SYS.DBMS_SQLTUNE_INTERNAL
585919c58 12719 package body SYS.DBMS_SQLTUNE_INTERNAL
585919c58 17400 package body SYS.DBMS_SQLTUNE_INTERNAL
551041008 6764 package body SYS.DBMS_STATS_INTERNAL
582933cc0 20153 package body SYS.DBMS_STATS
582933cc0 21081 package body SYS.DBMS_STATS
582933cc0 22271 package body SYS.DBMS_STATS
582933cc0 22974 package body SYS.DBMS_STATS
582933cc0 29553 package body SYS.DBMS_STATS
Stack trace:
kghfrempty kxsFreePersistentHe kxsCloseXscap kksCloseCursor opicca opiclo kpoclsa
opiodr kpoodrc rpiswu2 kpoodr upirtrc upirtr kpuping qksanAnalyzeSql qksanAnalyzeSegSql
kestsGatherSqlStati sticskestsProcessSqlCallout spefcmpaout spefmccallstd peftrusted
psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun
plsql_run peidxr_run peidxexe kkxdexe kkxmpexe kgmexwi kgmexec evapls evaopn2 kkxmexcs
opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute jslvec_execcb1
jslve_execute0 jslve_execute rpiswu2 kkjex1e kkjsexe kkjrdp opirip opidrv sou2o
opimai_real ssthrdmain main start
opiodr kpoodrc rpiswu2 kpoodr upirtrc upirtr kpuping qksanAnalyzeSql qksanAnalyzeSegSql
kestsGatherSqlStati sticskestsProcessSqlCallout spefcmpaout spefmccallstd peftrusted
psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun
plsql_run peidxr_run peidxexe kkxdexe kkxmpexe kgmexwi kgmexec evapls evaopn2 kkxmexcs
opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute jslvec_execcb1
jslve_execute0 jslve_execute rpiswu2 kkjex1e kkjsexe kkjrdp opirip opidrv sou2o
opimai_real ssthrdmain main start
Customer is using functional indexes
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |