Cache Filter Query Performance Degradation During Member Startup, Why? (Doc ID 2572151.1)

Last updated on OCTOBER 20, 2023

Applies to:

Goal

Customer has reported on 12.2.1.3.2 version, cache filter/query performance issue. They have a cache which has two indexes created (via ReflectionExtractor), the data is queried (using the entrySet method) using an AndFilter which is comprised of two EqualsFilters on the indexed methods. When starting new members, they see large performance degradation. Typically, the 90th percentile duration to perform the lookup is 23ms, but just after a new member has started and joined the cluster this time increases to 166ms for a short while.

Is there any way to avoid this temporary slowdown when a new member joins?
 

Solution

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