ORA-600 [kti_memory_leak] when creating TEXT index in a 32K block_size tablespace
(Doc ID 746477.1)
Last updated on MARCH 28, 2019
Applies to:Oracle Text - Version 10.2.0.4 and later
Information in this document applies to any platform.
Checked for relevance on 09-Jun-2010.
While creating CONTEXT indexes in a 32K blocksize tablespace, an error is logged in the alert.log:
ORA-00600: internal error code, arguments: [kti_memory_leak], , , , , , , 
Trace file shows:
INSERT /*+ SYS_DL_CURSOR */ INTO <owner>."DR$<index_name>$K" ("DOCID","TEXTKEY") VALUES
<- ktiassert <- ktiPoolOverflow <- kdilrub <- kdilroot_undoable
<- kdilcl0 <- kdblfx <- kdblfax <- kdblifl <- kdblfl
<- klafin <- kpodpfin <- kpodpmop <- opiodr
This error is generated while creating the second and subsequent TEXT indexes from the same session. For instance, if four (4) text indexes are being created consecutively from the same session, the 2nd, 3rd, and 4th TEXT index creation will EACH generate an ORA-600 [kti_memory_leak] in the alert.log. Note that although the error(s) occur, the TEXT indexes are created successfully with the status of VALID. This can be confirmed by querying USER_INDEXES as follows:
where ITYP_NAME = 'CONTEXT';
If creating more than nine (9) TEXT indexes consecutively from the same session, the 10th TEXT index creation will cause the user session to terminate with an ORA-3113. The first nine TEXT indexes are VALID while the 10th will have the status of INPROGS.
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