DBMS_STATS.GATHER_TABLE_STATS Fails With ORA-600 [16609]

(Doc ID 1068354.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms


1. The following errors are reported in the alert.log and generate a trace file:

2010-02-07 10:56:49.463
Dump continued from file: /oracle/diag/rdbms/obiprd/obiprd/trace/obiprd_ora_4039.trc
ORA-00600: internal error code, arguments: [16609], [0x49BAD92E0], [3905], [0], [], [], [], [], [], []

2. There may be a current SQL reported in the trace file:

select min(minbkt),maxbkt,substrb(dump(min(val),16,0,32),1,120) minval,substrb(dump(max(val),16,0,32),1,120) maxval,sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val,min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ parallel(t,4) parallel_index(t,4) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring */SUBSTR(TO_CHAR("TXN_MONTH_WID"),1,4) val, ntile(254) over (order by nlssort(SUBSTR(TO_CHAR("TXN_MONTH_WID"),1,4),'NLS_SORT = binary')) bkt from "SIEBEL"."WC_SALE_TRANSACTION_F" sample ( 1.0000000000) t where TBL$OR$IDX$PART$NUM("SIEBEL"."WC_SALE_TRANSACTION_F",0,4,0,"ROWID") = :objn and SUBSTR(TO_CHAR("TXN_MONTH_WID"),1,4) is not null) group by val) group by maxbkt order by maxbkt

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
497bb9938 15068 package body SYS.DBMS_STATS
497bb9938 15369 package body SYS.DBMS_STATS
497bb9938 17093 package body SYS.DBMS_STATS
497bb9938 17559 package body SYS.DBMS_STATS
497bb9938 17767 package body SYS.DBMS_STATS
497bb9938 18301 package body SYS.DBMS_STATS
497bb9938 18429 package body SYS.DBMS_STATS
49b492e80 610 package body OPS$ORACLE.STATS_OPERS_V10
493776680 51 package body SIEBEL.STATS_OPERS_PARALLEL
48f862fd8 1 anonymous bloc

3. The call stack will resemble:

ksedst1 <- ksedst <- dbkedDefDump <- dbgexPhaseII <- dbgexProcessError
<- dbgePostErrorKGE <- 1128 <- kgeade <- kgeriv_int <- kgeasi <-
kglsini <- kkdlVirCols <- qksvcInitVCContext <- qksvcProcessQbcRecu <-
rsePostTypeCheck <- qksvcProcessQbcRecu <- rsePostTypeCheck <- 248 <-
qksvcProcessQbcRecu <- rsePostTypeCheck <- opitca <- kksFullTypeCheck <-
rpiswu2 <- kksSetBindType <- kksfbc <- opiexe <- opipls <- opiodr
<- rpidrus <- skgmstack <- rpidru <- rpiswu2 <- rpidrv <- psddr0 <- psdnal <-
pevm_EXIM <- pfrinstr_EXIM <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt
<- kkxexe <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <-
opiodr <- opidrv <- sou2o <- main <- start

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