ORA-00600 [kdisle:nrows] On Oracle Text Indexes (Doc ID 2439384.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Internal error is generated during DML on table with Text index:

ORA-00600: internal error code, arguments: [kdisle:nrows], [1], [], [], [], [], [], [], [], [], [], []

Trace file shows:

----- Current SQL Statement for this session (sql_id=45x82yjcbkc8n) -----
INSERT INTO CTXSYS.DRV$DELETE2 (DEL_IDX_ID,DEL_IXP_ID,DEL_DOCID,DEL_UPDATED) VALUES(:idxid,:ixpid,:docid,:delupd)

----- Plan Table -----
---------------------------------------------+-----------------------------------+
| Id  | Operation                 | Name     | Rows  | Bytes | Cost  | Time      |
---------------------------------------------+-----------------------------------+
| 0   | INSERT STATEMENT          |          |       |       |     1 |           |
| 1   |  LOAD TABLE CONVENTIONAL  | DR$DELETE|       |       |       |           |
---------------------------------------------+-----------------------------------+

(CTXSYS.DRV$DELETE2 is a view on DR$DELETE)

Doing a full table scan of DR$DELETE generates an ORA-00600 [6006], [1] pointing to an issue with the primary key of the IOT table ctxsys.DR$DELETE:

ORACLE Instance bpk0p1 (pid = 35) - Error 600 encountered while recovering transaction (45, 37) on object 428882.
2018-07-31T09:49:48.921681-05:00
Errors in file /u01/app/oracle/diag/rdbms/bpk0p/bpk0p1/trace/bpk0p1_smon_76263.trc:
ORA-00600: internal error code, arguments: [6006], [1], [], [], [], [], [], [], [], [], [], []

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.