My Oracle Support Banner

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

Last updated on MARCH 27, 2019

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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("<COL1>")),to_char(substrb(dump(min("<COL2>"),16,0,32),1,120)),to_char(substrb(dump(max("<COL3>"),16,0,32),1,120)),to_char(count("<COL4>")),
---
to_char(substrb(dump(max("<COL50>"),16,0,32),1,120)) from "<SCHEMA>"."<TABLE_NAME>" 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
...

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


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