반응형
| 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 > TroubleShooting' 카테고리의 다른 글
| 오라클 패치 과정이 정상적으로 수행되지 않아 발생하는 문제 (0) | 2012.07.11 |
|---|---|
| DBMS_STATS.DELETE_TABLE_STATS Fails With ORA-600 [16515] [ID 1233745.1] (0) | 2012.04.28 |
| Unable To Start Instance due to ORA-7445 Dump In KSBNFY on Power Linux [ID 563895.1] (0) | 2012.04.20 |
| Ora-600 [Unable To Load Xdb Library] in AIX [ID 559911.1] (0) | 2012.04.20 |
| Memory Notification: Library Cache Object loaded into SGA (0) | 2012.03.06 |
