ORA-600 [kghfrempty:ds] And ORA-600 [kghrcdepth:ds] While Gathering Statistics (Doc ID 1480132.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.0. to 11.2.0.2.0 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2014***

Symptoms

ORA-600 [kghfrempty:ds] followed by ORA-600 [kghrcdepth:ds] can be seen while gathering stats.

Alert.log:

Errors in file /u01/app/oracle/e26/diag/rdbms/e26/E26/trace/E26_j005_27256.trc  (incident=245244):
ORA-00600: internal error code, arguments: [kghfrempty:ds], [0xFFFFFFFF78DE0038], [], [], [], [], [], [], [], [], [], []
Incident details in: /u01/app/oracle/e26/diag/rdbms/e26/E26/incident/incdir_245244/E26_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 /u01/app/oracle/e26/diag/rdbms/e26/E26/trace/E26_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: /u01/app/oracle/e26/diag/rdbms/e26/E26/incident/incdir_245245/E26_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("ID")),to_char(substrb(dump(min("ID"),16,0,32),1,120)),to_char(substrb(dump(max("ID"),16,0,32),1,120)),to_char(count("BER_ID")),to_char(substrb(dump(min("BER_ID"),16,0,32),1,120)),
to_char(substrb(dump(max("BER_ID"),16,0,32),1,120)),to_char(count("RKMG_ID")),to_char(substrb(dump(min("RKMG_ID"),16,0,32),1,120)),to_char(substrb(dump(max("RKMG_ID"),16,0,32),1,120)),
to_char(count("FORMEL")),to_char(substrb(dump(min("FORMEL"),16,0,32),1,120)),to_char(substrb(dump(max("FORMEL"),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

 

Customer is using functional indexes

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