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

Last updated on APRIL 10, 2024

Applies to:

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

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