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

Last updated on APRIL 23, 2017

Applies to:

Oracle Coherence - Version 3.7.1.1 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms