My Oracle Support Banner

Oracle Text Context Index Performance Impact When Using TRANSACTIONAL Option (Doc ID 1497140.1)

Last updated on JUNE 21, 2022

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.


We use Oracle Text CONTEXT index and it is important to have TRANSACTIONAL search enabled.
However turning on the "TRANSACTIONAL" option can cause significant performance degradation in all DMLs performed on the base table.
According to traces we've collected, there is significant amount of IO wasted on queries that were prepared recursively as result of the UPDATE .

Are there any know performance issues with this option? Are the any know best practices how to bypass these problems?


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

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