How To Work with Coherence Query Explain plan and Trace Statements? (Doc ID 2253598.1)

Last updated on NOVEMBER 17, 2023

Applies to:

Goal

Prior to Coherence 3.6 developers were required to perform queries against caches using a filtering mechanism which, while concise and efficient, required a fair amount of developer effort to code correctly. Coherence 3.6, introduced the Coherence Query Language or CohQL, a lightweight SQL like language for performing select type operations on caches. Coherence 3.7 introduced additional functionality to support selections but focused on performance.

Q1: How to check what indexes are present on a given cache?
Q2: Non-optimized queries shown on storage MBeans does not give the time when the query was run, is there a way to get the time when the non-optimized queries were run?
Q3: How do we know when these queries were run on the cluster?

Solution

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