My Oracle Support Banner

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 later
Oracle Database - Enterprise Edition - Version to [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.


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


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

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)),

----- 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




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.