How To Work with Coherence Query Explain plan and Trace Statements?
(Doc ID 2253598.1)
Last updated on NOVEMBER 12, 2020
Applies to:Oracle Coherence - Version 184.108.40.206 and later
Information in this document applies to any platform.
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?
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