Ora-00600 [Kghrcdepth:Ds] hit by dbms_stats.gather_database_stats_job_proc (Doc ID 1234304.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Oct-2013***

Symptoms

On 11.1.0.7 database, when using dbms_stats.gather_database_stats_job_proc(), following errors are raised:

ORA-00600: internal error code, arguments: [kghrcdepth:ds], [0x11096AF90], [], [], [], [], [], [], []
ORA-07445: exception encountered: core dump [PC:0xF524] [SIGSEGV] [ADDR:0x21090C901] [PC:0xF524] [Address not mapped to object] []


The trace file shows the current SQL statement. PL/SQL stack and Call Stack Trace for this session:

/* SQL Analyze(264,1) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */to_char(count("RULE_ID")),to_char(substrb(dump(min("RULE_ID"),16,0,32),1,120)),to_char(substrb(dump(max("RULE_ID"),16,0,32),1,120)),to_char(count("TIME_UNIT")),to_char(substrb(dump(min("TIME_UNIT"),16,0,32),1,120)),to_char(substrb(dump(max("TIME_UNIT"),16,0,32),1,120)),to_char(count("INTERVAL_LENGTH")),to_char(substrb(dump(min("INTERVAL_LENGTH"),16,0,32),1,120)),to_char(substrb(dump(max("INTERVAL_LENGTH"),16,0,32),1,120)),to_char(count("IS_PERIOD")),to_char(substrb(dump(min("IS_PERIOD"),16,0,32),1,120)),to_char(substrb(dump(max("IS_PERIOD"),16,0,32),1,120)),to_char(count("LAST_PSL_RECORD_DATE")),to_char(substrb(dump(min("LAST_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("LAST_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(count("FIRST_COMPLETE_PSL_RECORD_DATE")),to_char(substrb(dump(min("FIRST_COMPLETE_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("FIRST_COMPLETE_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(count("LAST_COMPLETE_PSL_RECORD_DATE")),to_char(substrb(dump(min("LAST_COMPLETE_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("LAST_COMPLETE_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(count("LAST_PSL_CYCLE_DATE")),to_char(substrb(dump(min("LAST_PSL_CYCLE_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("LAST_PSL_CYCLE_DATE"),16,0,32),1,120)),to_char(count("FORMULA_ID")),to_char(substrb(dump(min("FORMULA_ID"),16,0,32),1,120)),to_char(substrb(dump(max("FORMULA_ID"),16,0,32),1,120)),to_char(count("FIRST_COMPLETE_MODIFY_DATE")),to_char(substrb(dump(min("FIRST_COMPLETE_MODIFY_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("FIRST_COMPLETE_MODIFY_DATE"),16,0,32),1,120)),to_char(count("STATUS")),to_char(substrb(dump(min("STATUS"),16,0,32),1,120)),to_char(substrb(dump(max("STATUS"),16,0,32),1,120)),to_char(count("MIN_TIME_NEW_RAW_DATA")),to_char(substrb(dump(min("MIN_TIME_NEW_RAW_DATA"),16,0,32),1,120)),to_char(substrb(dump(max("MIN_TIME_NEW_RAW_DATA"),16,0,32),1,120)),to_char(count("MIN_TIME_OF_CORRECTION")),to_char(substrb(dump(min("MIN_TIME_OF_CORRECTION"),16,0,32),1,120)),to_char(substrb(dump(max("MIN_TIME_OF_CORRECTION"),16,0,32),1,120)),to_char(count("MIN_TIME_NOT_USED")),to_char(substrb(dump(min("MIN_TIME_NOT_USED"),16,0,32),1,120)),to_char(substrb(dump(max("MIN_TIME_NOT_USED"),16,0,32),1,120)),to_char(count("MIN_TIME_OF_EXCEPTION")),to_char(substrb(dump(min("MIN_TIME_OF_EXCEPTION"),16,0,32),1,120)),to_char(substrb(dump(max("MIN_TIME_OF_EXCEPTION"),16,0,32),1,120)),to_char(count("MIN_TIME_OF_VERSION")),to_char(substrb(dump(min("MIN_TIME_OF_VERSION"),16,0,32),1,120)),to_char(substrb(dump(max("MIN_TIME_OF_VERSION"),16,0,32),1,120)),to_char(count("LAST_RT_ERROR_CODE")),to_char(substrb(dump(min("LAST_RT_ERROR_CODE"),16,0,32),1,120)),to_char(substrb(dump(max("LAST_RT_ERROR_CODE"),16,0,32),1,120)),to_char(count("LAST_RT_ERROR")),to_char(substrb(dump(min("LAST_RT_ERROR"),16,0,32),1,120)),to_char(substrb(dump(max("LAST_RT_ERROR"),16,0,32),1,120)),to_char(count("RULE_TU_CREATE_DATE")),to_char(substrb(dump(min("RULE_TU_CREATE_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("RULE_TU_CREATE_DATE"),16,0,32),1,120)),to_char(count("RULE_TU_MODIFY_DATE")),to_char(substrb(dump(min("RULE_TU_MODIFY_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("RULE_TU_MODIFY_DATE"),16,0,32),1,120)),to_char(count("MIN_TIME_INTERMEDIATE_DATA")),to_char(substrb(dump(min("MIN_TIME_INTERMEDIATE_DATA"),16,0,32),1,120)),to_char(substrb(dump(max("MIN_TIME_INTERMEDIATE_DATA"),16,0,32),1,120)),to_char(count("FREEZE_DATE_LINE")),to_char(substrb(dump(min("FREEZE_DATE_LINE"),16,0,32),1,120)),to_char(substrb(dump(max("FREEZE_DATE_LINE"),16,0,32),1,120)),to_char(count("CALC_DATE_LINE")),to_char(substrb(dump(min("CALC_DATE_LINE"),16,0,32),1,120)),to_char(substrb(dump(max("CALC_DATE_LINE"),16,0,32),1,120)),to_char(count("FORECAST_CALCULATION_DATE")),to_char(substrb(dump(min("FORECAST_CALCULATION_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("FORECAST_CALCULATION_DATE"),16,0,32),1,120)),to_char(count("AGENT_HAS_BEEN_PURGED")),to_char(substrb(dump(min("AGENT_HAS_BEEN_PURGED"),16,0,32),1,120)),to_char(substrb(dump(max("AGENT_HAS_BEEN_PURGED"),16,0,32),1,120)),to_char(count("AGENT_FULLY_CALCULATED")),to_char(substrb(dump(min("AGENT_FULLY_CALCULATED"),16,0,32),1,120)),to_char(substrb(dump(max("AGENT_FULLY_CALCULATED"),16,0,32),1,120)),to_char(count("LATEST_VALID_PSL_RECORD_DATE")),to_char(substrb(dump(min("LATEST_VALID_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("LATEST_VALID_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(count("CALCULATION_VALID_UPTO")),to_char(substrb(dump(min("CALCULATION_VALID_UPTO"),16,0,32),1,120)),to_char(substrb(dump(max("CALCULATION_VALID_UPTO"),16,0,32),1,120)),to_char(count("LATEST_EVER_PSL_RECORD_DATE")),to_char(substrb(dump(min("LATEST_EVER_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("LATEST_EVER_PSL_RECORD_DATE"),16,0,32),1,120)),to_char(count("IS_IN_RECALCULATION")),to_char(substrb(dump(min("IS_IN_RECALCULATION"),16,0,32),1,120)),to_char(substrb(dump(max("IS_IN_RECALCULATION"),16,0,32),1,120)),to_char(count("LATEST_CALCULATION_DATE")),to_char(substrb(dump(min("LATEST_CALCULATION_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("LATEST_CALCULATION_DATE"),16,0,32),1,120)),to_char(count("PREV_INTER_DATA_ID")),to_char(substrb(dump(min("PREV_INTER_DATA_ID"),16,0,32),1,120)),to_char(substrb(dump(max("PREV_INTER_DATA_ID"),16,0,32),1,120)),to_char(count("CANCELLED_AGENT_WAS_PROCESSED")),to_char(substrb(dump(min("CANCELLED_AGENT_WAS_PROCESSED"),16,0,32),1,120)),to_char(substrb(dump(max("CANCELLED_AGENT_WAS_PROCESSED"),16,0,32),1,120)),to_char(count("RECALCULATION_SOURCE_ID")),to_char(substrb(dump(min("RECALCULATION_SOURCE_ID"),16,0,32),1,120)),to_char(substrb(dump(max("RECALCULATION_SOURCE_ID"),16,0,32),1,120)),to_char(count("RECALCULATION_DATE")),to_char(substrb(dump(min("RECALCULATION_DATE"),16,0,32),1,120)),to_char(substrb(dump(max("RECALCULATION_DATE"),16,0,32),1,120)),to_char(count("RECALCULATION_CODE")),to_char(substrb(dump(min("RECALCULATION_CODE"),16,0,32),1,120)),to_char(substrb(dump(max("RECALCULATION_CODE"),16,0,32),1,120)),to_char(count("RECALCULATION_MODULE")),to_char(substrb(dump(min("RECALCULATION_MODULE"),16,0,32),1,120)),to_char(substrb(dump(max("RECALCULATION_MODULE"),16,0,32),1,120)),to_char(count("METRIC_SENDER_ID")),to_char(substrb(dump(min("METRIC_SENDER_ID"),16,0,32),1,120)),to_char(substrb(dump(max("METRIC_SENDER_ID"),16,0,32),1,120)) from "OBLICORE"."T_RULES_TIME_UNITS" t /* NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL*/
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
7000000287b3c20 134 package body SYS.DBMS_SQLTUNE_INTERNAL
7000000287b3c20 7527 package body SYS.DBMS_SQLTUNE_INTERNAL
7000000287b3c20 8161 package body SYS.DBMS_SQLTUNE_INTERNAL
7000000287b3c20 11813 package body SYS.DBMS_SQLTUNE_INTERNAL
700000047cbe318 5470 package body SYS.DBMS_STATS_INTERNAL
7000000288dd4e8 16417 package body SYS.DBMS_STATS
7000000288dd4e8 16974 package body SYS.DBMS_STATS
7000000288dd4e8 17810 package body SYS.DBMS_STATS
7000000288dd4e8 18301 package body SYS.DBMS_STATS
7000000288dd4e8 24200 package body SYS.DBMS_STATS

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

1st error
...
qeaeMin qergsFetch opifch2 kpoal8 opiodr kpoodrc rpiswu2 kpoodr upirtrc kpurcsc kpufch OCIStmtFetch2 qksanAnalyzeSql qksanAnalyzeSegSql kestsGatherSqlStatistics kestsProcessSql kestsProcessSqlCall
...

2nd error
...
kghnerror kghrcappl kghfrempty_ex qesmmIPgaFreeCb ksu_dispatch_tac krr_thread_read krr_read_buffer krr_parse_redo kcra_scan_redo kcra_dump_redo kcra_dump_redo_internal
...

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