My Oracle Support Banner

Instance Terminated: Errors in the Alert Log: ORA-600[kcbgtcr_19] ORA-600[kcbkvaq_2] ORA-600[kcbkllrba_2] (Doc ID 2449566.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

The instance terminated with the following errors in the alert log:

ORA-00600: internal error code, arguments: [kcbgtcr_19], [255], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kcbkvaq_2], [1], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQLTUNE_INTERNAL", line 12825
ORA-06512: at "SYS.WRI$_ADV_SQLTUNE", line 7
ORA-06512: at "SYS.PRVT_ADVISOR", line 602
ORA-06512: at "SYS.PRVT_ADVISOR", line 2678
ORA-06512: at "SYS.DBMS_ADVISOR", line 241
ORA-06512: at "SYS.DBMS_SQLTUNE", line 937
ORA-06512: at line 19
ORA-32701: Possible hangs up to hang ID=1 detected
ORA-00600: internal error code, arguments: [kcbkllrba_2], [], [], [], [], [], [], [], [], [], [], []

 

The Current SQL Statement in the incident trace file associated with the 1st ORA-600[kcbgtcr_19] error shows:

SELECT /* DS_SVC */ /*+ dynamic_sampling(0) no_sql_tune no_monitoring optimizer_features_enable(default) no_parallel */ sum(vsize(C1))/count(*) , SUM(C2), COUNT(DISTINCT C3), sum(vsize(C4))/count(*) FROM (SELECT /*+ qb_name("innerQuery") NO_INDEX_FFS( "EVENT_ARCHIVE") */ "EVENT_ARCHIVE"."EVENT_TYPE" AS C1, CASE WHEN ("EVENT_ARCHIVE"."ENTITY_ID" IS NULL) THEN 1 ELSE 0 END AS C2, "EVENT_ARCHIVE"."ENTITY_ID" AS C3, "EVENT_ARCHIVE"."ENTITY_ID" AS C4 FROM "HPERM"."EVENT_ARCHIVE" SAMPLE BLOCK(0.09519, 4) SEED(9) "EVENT_ARCHIVE") innerQuery

 

It also shows these involved objects:

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x9cf0daa18 12825 package body SYS.DBMS_SQLTUNE_INTERNAL
0x7753b0eb8 7 SYS.WRI$_ADV_SQLTUNE
0x9cf0e9bc0 602 package body SYS.PRVT_ADVISOR
0x9cf0e9bc0 2678 package body SYS.PRVT_ADVISOR
0x9df153990 241 package body SYS.DBMS_ADVISOR
0x9d724b8d8 937 package body SYS.DBMS_SQLTUNE
0x9d7077748 19 anonymous block

 and this Call Stack Trace:

kcbgtcr <- ktrget2 <- kdstgr <- qertbFetch <- qergiFetch <- qergiFetch <- qerghFetch
 <- qervwFetch <- qergsFetch <- opifch2 <- opiall0 <- opikpr <- opiodr <- rpidrus <- skgmstack
  <- rpiswu2 <- kprball <- qksdsExeStmt <- qksdsExecute <- kkoatTabStatsCollectAll
   <- kkoatStatsCollectTab <- kkoatStatsCollect <- kkoipt <- kkoqbc <- apakkoqb
    <- apaqbdDescendents <- apadrv <- opitca <- kksFullTypeCheck <- rpiswu2 <- kksLoadChild
     <- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <- opiosq0 <- kpoal8 <- opiodr
      <- kpoodrc <- rpiswu2 <- kpoodr

 

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.