Database FTX Search Slow And Receiving Errors From Oracle DB Ora-01013 (Doc ID 867748.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.0 and later
Information in this document applies to any platform.

Goal

The Server is a 10gR3 install with patch updates. System performance is bad going straight to
the database when using the query that is built from the Content Server with certain operators.
Anything that uses "is not null" will not use the Database index. Substring is also bad as
that will not use an DB index either. We are using CIS to send specific queries (Matches
operator) and starts with instead of substring but this doesn't fix the "is not null" problem.
What can be done to speed the queries?



Solution

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