GATHER_SCHEMA_STATS Fails With ORA-00600 [ktsircinfo_num1] and/or [25027] (Doc ID 875902.1)

Last updated on OCTOBER 11, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 and later ]
Information in this document applies to any platform.

Symptoms

GATHER_SCHEMA_STATS fails with
ORA-00600: internal error code, arguments: [ktsircinfo_num1], [416], [0], [0], [], [], [], []

Example of the failing statement is:

BEGIN FND_STATS.GATHER_SCHEMA_STATS(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4,:A5,:A6,:A7,:A8); END;
----- PL/SQL Call Stack -----
object line object
handle number name
417c093b8 137 package body SYS.DBMS_SPACE
416d8e690 62 package body APPS.FND_STATS
416d8e690 1409 package body APPS.FND_STATS
416d8e690 1004 package body APPS.FND_STATS
416d8e690 1210 package body APPS.FND_STATS
416d8e690 782 package body APPS.FND_STATS
417c0ea40 1 anonymous block


Call stack looks similar too:

ksedmp <- kgerinv <- kgeasnmierr <- ktsircinfo1 <- ktsircinfo <-
ktsagob <- ktsausp <- ktsapus <- pevm_icd_call_commo <- pfrinstr_ICAL <-
pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe <-
opiall0 <- opial7 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
<- opidrv <- sou2o <- opimai_real <- main <- start

If you run the hcheck script as per <> you find out that there's an orphan table:

Problem: Orphaned TAB$ (no SEG$)
ORPHAN TAB$: OBJ=811662 DOBJ=811662 TS=416 RFILE/BLOCK=0 0 BOBJ#= SegType=
SEG$ has no UET$ entry: TS#=0 RFILE#=352 BLK#=45908 TYPE#=9
NB: TYPE#=9 is special and may be OK

From the above output the problematic table has the object number 811662.

SQL> Select name,dataobj#, owner#, type#, status,flags from obj$ where obj#=811662;

NAME DATAOBJ# OWNER# TYPE# STATUS
------------------------------ ---------- ---------- ---------- ----------
FLAGS
----------
OKC_TIMEVALUES 811662 106 2 1
0

SQL> exec fnd_stats.gather_table_stats('OKC', 'OKC_TIMEVALUES') ;
BEGIN fnd_stats.gather_table_stats('OKC', 'OKC_TIMEVALUES') ; END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25027], [416], [0], [], [], [],
ORA-06512: at "APPS.FND_STATS", line 1506
ORA-06512: at line 1 

SQL> exec DBMS_STATS.gather_table_stats('OKC', 'OKC_TIMEVALUES') ;
BEGIN DBMS_STATS.gather_table_stats('OKC', 'OKC_TIMEVALUES') ; END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [25027], [416], [0], [], [], [],[],
ORA-06512: at "SYS.DBMS_STATS", line 13437
ORA-06512: at "SYS.DBMS_STATS", line 13457
ORA-06512: at line 1

Using dbms_stats.gather_schema_stats instead of FND_STATS.GATHER_SCHEMA_STATS also fails as seen above.

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