Ora-600 [kzpivop:valid_obtypid] From Gather_fixed_object_stats

(Doc ID 1101423.1)

Last updated on NOVEMBER 10, 2016

Applies to:

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

Symptoms

Executing DBMS_STATS.gather_fixed_object_stats failed with following error: ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [kzpivop:valid_obtypid]

Stack:
----- Call Stack Trace -----
ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- PGOSF184_ksfdmp
<- dbgexPhaseII <- dbgexProcessError <- dbgeExecuteForError <- dbgePostErrorKGE <- 1608
<- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal <- kgerinv <- kgeasnmierr
<- kzpivop <- kzpopcb <- qerfxFetch <- qerandvFetch <- qergsFetch
<- opifch2 <- kpoal8 <- opiodr <- PGOSF517_kpoodrc <- rpiswu2
<- kpoodr <- xupirtrc <- upirtrc <- kpurcsc <- kpufch0
<- kpufch <- OCIStmtFetch2 <- qksanAnalyzeSql <- 675 <- qksanAnalyzeSegSql
<- kestsGatherSqlStati <- stics <- kestsProcessSql <- kestsProcessSqlCall <- out
<- spefcmpa <- out <- spefmccallstd <- pextproc <- peftrusted
<- PGOSF519_psdexsp <- rpiswu2 <- psdextp <- pefccal <- pefcal
<- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run
<- peicnt <- kkxexe <- opiexe <- kpoal8 <- opiodr
<- ttcpip <- opitsk <- opiino <- opiodr <- opidrv
<- sou2o <- opimai_real <- opimai <- OracleThreadStart <- 0000000077D6B71A

Changes

You had applied a bundle patch to the database server recently.

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