My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2021

Applies to:

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


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.


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

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