ORA-600 [kti_memory_leak] when creating TEXT index in a 32K block_size tablespace
(Doc ID 746477.1)
Last updated on JANUARY 31, 2022
Applies to:
Oracle Text - Version 10.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
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
(NULL,NULL)
Stack trace:
<- 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:
from USER_INDEXES
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.
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 |
| Cause |
| Solution |
| References |