My Oracle Support Banner

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

Last updated on FEBRUARY 10, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A 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 <Note 136697.1> 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.

Changes

 

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
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.