ORA-600 [15815] When Using DBMS_STATS On Table With Function Based Index (Doc ID 1092675.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.0 to 11.2.0.2.0 [Release 11.2]
Information in this document applies to any platform.

Symptoms

1. You see an ORA-600 [15815] when using DBMS_STATS on a table with a function-based index. 

2. It reproduces with both gather_schema_stats and gather_table_stats.

3. It has the following call stack

skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ksfdmp
<- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE
<- 1615 <- dbkePostKGE_kgsf <- kgeade <- kgeriv_int <- kgeriv <- kgeasi
<- kxfqupp <- kxfqira <- qerpxFetch <- kpofrws <- opifch2 <- opifch <- opipls
<- opiodr <- PGOSF141_rpidrus <- skgmstack <- rpiswu2 <- rpidrv <- psddr0 <- psdnal
<- pevm_BFTCHC <- pfrinstr_FTCHC <- pfrrun_no_tool <- pfrrun <- plsql_run <- peidxr_run
<- peidxexe <- kkxdexe <- kkxmpexe <- kgmexwi <- kgmexec <- evapls <- evaopn2 <- kkxmexcs
<- opiexe <- kpoal8 <- opiodr <- kpoodr <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute
<- jslvec_execcb1 <- jslvswu <- jslve_execute0 <- jslve_execute <- rpiswu2 <- kkjex1e
<- kkjsexe <- kkjrdp <- opirip <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
<- libc_start_main <- start

Changes

A function-based index is created on column with date data type.

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