Database FTX Search Slow And Receiving Errors From Oracle DB Ora-01013
Last updated on FEBRUARY 05, 2018
Applies to:Oracle WebCenter Content - Version 10.1.3.3.0 and later
Information in this document applies to any platform.
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?
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