ORA-00600 [Kdu_array_buf:Depth], [17], [16] reported.
(Doc ID 1414343.1)
Last updated on FEBRUARY 24, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Information in this document applies to any platform.
Symptoms
The following error is reported by alert log
The trace file confirms:
----------------
kdu_array_buf kduurp kdusru kdu_retry_update kdu_array_flush ...
----- Incident Context Dump -----
...
[01]: kdu_array_buf []<-- Signaling
[02]: kduurp []
[03]: kdusru []
[04]: kdu_retry_update []
[05]: kdu_array_flush []
[06]: kdu_retry_update []
[07]: kdu_array_flush []
[08]: kdu_retry_update []
[09]: kdu_array_flush []
[10]: kdu_retry_update []
...
Changes
The ORA-600 occurs when SMON performs maintenance on Undo Tablespace (such as shrinking an Undo Segment). This might not be obvious when reading the trace file as this might show a DML statement such as illustrated by the following trace information:
----- Current SQL Statement for this session (sql_id=1vwg99k24trd0) -----
update "xxx"."MLOG$_yyyyy" set snaptime$$ = :1 where rowid in
(select rowid from "OPI"."MLOG$_yyy_" AS OF SNAPSHOT (:2)
log$ where snaptime$$ >
to_date('2100-01-01:00:00:00','YYYY-MM-DD:HH24:MI:SS'))
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
47e5d9948 84 package body SYS.DBMS_SNAPSHOT
47e5d9948 1808 package body SYS.DBMS_SNAPSHOT
47e5d9948 2506 package body SYS.DBMS_SNAPSHOT
47e5d9948 2751 package body SYS.DBMS_SNAPSHOT
47e5d9948 2720 package body SYS.DBMS_SNAPSHOT
...
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |