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 NOVEMBER 30, 2012

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms