ORA-07445 [kkoatVerifyIdxAccDerive()+1692] for 18.1
(Doc ID 2648900.1)
Last updated on APRIL 30, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 18.1.0.0.0 and laterInformation in this document applies to any platform.
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
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 |
Cause |
Solution |
References |