Gathering Statistics using DBMS_STATS Raises error: "ORA-00600: , , , , "
(Doc ID 1076905.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Information in this document applies to any platform.
- Collecting database statistics as given below is failing with an ORA-600 error:
SQL> exec DBMS_STATS.GATHER_TABLE_STATS('<schema name>','<table name>');
ERROR at line 1:
ORA-00600: internal error code, arguments: , , , , , ,,, , , , 
ORA-06512: at "SYS.DBMS_STATS", line 20337
ORA-06512: at "SYS.DBMS_STATS", line 20360
ORA-06512: at line 1
- From the trace the error has the following call stack:
ksxb1qb <- qerwnFetch <- qervwFetch <- qernsFetch
<- qervwFetch <- qergsFetch <- opifch2 <- opifch <- opipls
<- opiodr <- PGOSF141_rpidrus <- skgmstack <- rpiswu2 <- rpidrv
- The object being gathered against contains at least one function based index
- Query generated by the gather routine includes a group by clause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!