ORA-07445 [kkoatVerifyIdxAccDerive()+1692] for 18.1 (Doc ID 2648900.1)

Last updated on APRIL 30, 2020

Applies to:

Symptoms

• Seeing the following error ORA-07445: exception encountered: core dump [kkoatVerifyIdxAccDerive()+1692]:  
  STACK TRACE:
  kkoatVerifyIdxAccDerive <- kkoatVerifyIdxAcc <- kkeAdjIndexSel <- kkessc <- kkeidc
  <- kketac <- kkonxc <- kkotap <- kkojnp <- kkocnp <- kkooqb <- kkoqbc <- apakkoqb
  <- apaqbdDescendents <- apaqbd <- kkqctFullCostTransfQB <- kkqctdrvORE <- kkqoregdtr
  <- qksqbApplyToQbcLoc <- qksqbApplyToQbc <- kkqctdrvTD <- kkqoredrv <- kkqdrv
  <- kkqctdrvIT <- apadrv <- opitca <- kksSetBindType <- kksfbc <- opiexe <- kpoal8 <- opiodr
  <- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute
  <- qksanExecSql <- qksanAnalyzeSqlConCbk <- qksanAnalyzeSql
  
  
  CURRENT SQL:
  /* SQL Analyze(250,1) */ SELECT DISTINCT Lb.Lok_Bez Lok_Bez FROM Mkl_Vstrukt_Sum Mklvs JOIN V_Lokation_Basis Lb ON Lb.Sm_Lok_Id = Mklvs.N_Sm_Lok_Id WHERE Lb.Ve_Id = :PAR_VEID AND Lb.Loeschvormerkung_Flag = 'N' AND Lb.Lok_Typ_Bez IN ('VERS','VRSL','VRSK') AND Mklvs.MKL_Id = :MFF_MKL_ID AND Mklvs.Anza...

  PL/SQL STACK:
  object line object
  handle number name
  0x15d437338 14032 package body SYS.DBMS_SQLTUNE_INTERNAL.I_SUB_EXECUTE_CALLOUT
  0x15d437338 14059 package body SYS.DBMS_SQLTUNE_INTERNAL.I_SUB_EXECUTE
  0x1562975e0 8 type body SYS.WRI$_ADV_SQLTUNE.SUB_EXECUTE
  0x15e3159d8 800 package body SYS.PRVT_ADVISOR.COMMON_SUB_EXECUTE
  0x15e3159d8 3294 package body SYS.PRVT_ADVISOR.COMMON_EXECUTE_TASK
  0x169cbcfd0 262 package body SYS.DBMS_ADVISOR.EXECUTE_TASK
  0x168f79a08 1217 package body SYS.DBMS_SQLTUNE.EXECUTE_TUNING_TASK
  0x16663cc48 19 anonymous block

    
  

   

Cause

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