DBMS_STATS.DELETE_TABLE_STATS Fails With ORA-600 [16515] (Doc ID 1233745.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.6 to 10.2.0.5 [Release 9.2 to 10.2]
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The symptoms are ORA-600[16515] when trying to delete statistics.


ORA-600 message:
ORA-00600: internal error code, arguments: [16515], [D], [2], [310302], [17], [1], [], []

The failing query:
begin
dbms_stats.delete_table_stats ( ownname => user, tabname => '<TABLE_NAME>', cascade_parts => true, cascade_columns => true, cascade_indexes => true, force => true);
end;
/

The call stack:
ksedst ksedmp ksfdmp kgeriv kgesiv ksesic5 kqdhsu kqrcmt ktcrcm kdapscs spefcmpa
spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal

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