Search Cache Is Bypassed For Query That Returns No Results (Doc ID 1498273.1)

Last updated on NOVEMBER 03, 2016

Applies to:

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

Symptoms

If you run a query using GET_SEARCH_RESULTS that returns no results it skips the search cache and still makes the database calls the second time you run the query. This causes an unnecessary performance hit.  Steps to show behavior:

1. Turn on the searchcahe, searchquery, systemdatabase trace sections with verbose output
2. Run a query you know returns no results, e.g. dDocName `1234`
3. Run the query again
4. check the trace output, you will see that the second time you ran the query it went back to the database again, even when it says it found the query in the cache.

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