My Oracle Support Banner

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

Last updated on APRIL 10, 2024

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

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
References


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