Ora-600 [16515] Reported While Gathering Statistics

Ora-600 [16515] Reported While Gathering Statistcs [ID 1277293.1]
		수정 날짜 18-MAY-2011     유형 PROBLEM     상태 MODERATED

In this Document
  Symptoms
  Cause
  Solution

---

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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

Internal error ORA-600 [16515] is randomly reported in different DB objects while gathering statistics, by example:

ORA-00600: internal error code, arguments: [16515], [U], [40], [78116], [2]
ORA-00600: internal error code, arguments: [16515], [D], [40], [76516], [1]

Cause

The ORA-600 [16515] error here occurs due to corrupt histogram statistics existing for the object being analyzed.
 
You can identify the table being analyzed from the fourth argument in the ORA-600 error,
e.g.
for "ORA-00600: internal error code, arguments: [16515], [U], [40], [78116], [2], would be object 78116.

And you could locate the object with query:

select owner, object_name, object_type
from sys.dba_objects
where object_id = 78116;

Solution

Delete the table statistics for the involved object using:

connect / as sysdba
exec dbms_stats.delete_table_stats(ownname=> '<Table Owner>', tabname=> '<Table Name>');

Once done, then see if the problem still occurs the following day after the instance restart.

관련 자료 제품 Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition