My Oracle Support Banner

Why are more queries executed in GET_SEARCH_RESULTS when search is submitted from client application (e.g., IPM)? (Doc ID 2618827.1)

Last updated on DECEMBER 10, 2019

Applies to:

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

Symptoms

The following queries are seen in systemdatabase tracing for the GET_SEARCH_RESULTS when the search is from Imaging (IPM).  The queries are executed towards the end after the search query had executed. These aren't executed however when the same search is executed from CS native UI.

 

The same query is executed for every 25 documents returned in the search results.  So, if Max Results was set to 10000 from Imaging, then the above query would execute 400 times.  Therefore, it's causing additional load and execution time to complete the search.

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
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.