Gathering Statistics using DBMS_STATS Raises error: "ORA-00600: , , , , "
(Doc ID 1076905.1)
Last updated on MARCH 28, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2]
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.
- 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!
In this Document