How To Work with Coherence Query Explain plan and Trace Statements?
Last updated on APRIL 23, 2017
Applies to:Oracle Coherence - Version 220.127.116.11 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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms