Slow Oracle Text Filtering or Text does Not Index some PDFs on 11.1.0.7, 11.2.0.1 - Workaround using USER_FILTER
(Doc ID 1450561.1)
Last updated on JANUARY 10, 2020
Applies to:
Oracle Text - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]Oracle Text - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
Symptoms
Performance degradation after upgrade from 10.2.0.4 to 10.2.0.5 or upgrade from 10.2.0.4 to 11.1.0.7 or upgrade from 10.2.0.4 to 11.2.0.1 on indexing or synchronizing documents with AUTO_FILTER or filtering timeout errors for larger PDF files in ctx_user_index_errors view like
Changes
Database was upgraded:
from 10.2.0.4 to 10.2.0.5
or
from 10.2.0.4 to 11.1.0.7
or
from 10.2.0.4 to 11.2.0.1.
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 |