When Using a Database Choice List in the Capture Client, the Results Load Very Slowly When Compared to Querying the Table in SQL Developer

(Doc ID 2354858.1)

Last updated on FEBRUARY 02, 2018

Applies to:

Oracle WebCenter Enterprise Capture - Version 11.1.1.8.0 to 12.2.1.3.0 [Release 11g to 12c]
Information in this document applies to any platform.

Goal

When using the Oracle WebCenter Enterprise Capture Client to perform indexing with a Database Choice List, the choice list takes a long time to display the results to the user.  If attempting to query this same table in SQL Developer, much quicker performance is seen.  How can Indexing times be improved when working with database results?

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