My Oracle Support Banner

How to Query the Coherence*Web session-storage cache in the 12.2.1.x.x versions (Doc ID 2323536.1)

Last updated on NOVEMBER 21, 2023

Applies to:

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


Customer raised question how to query the coherence*web session caches using the COHQL client in the 12c (12.2.1.x.x) versions when federation is enabled for the coherence*web.

The Coherence federated caching feature replicates cache data asynchronously across multiple geographically dispersed clusters. Coherence*Web can take advantage of federated caching to provide redundancy, off-site backup, and multiple points of access for application users that are in different geographical locations. For details about Federated caching, see Administering Oracle Coherence.

To use federated caching for HTTP session caches:

  1. Define federation cluster participants and topologies. For detailed instructions, see Administering Oracle Coherence.
  2. Configure Coherence*Web to use a federated cache scheme. A default session cache configuration file is included in the coherence-web.jar library and is called default-federated-session-cache-config.xml session cache configuration file. To use the default federated session cache configuration file, use the coherence-session-cache-federated context parameter with the value set to true.
  3. Update or override the default-federated-session-cache-config.xml session cache configuration file and associate the default federated caching scheme (session-distributed) with a replication topology. For detailed instructions, see Administering Oracle Coherence. For example:
Note: That step 3 is optional in the later because In the version Federated caching support in WebLogic Server Console, which simplifies configuration when federating session data across clusters. See "Enabling the Coherence Session Cache in Weblogic Server Administration Console."


  1. Is it supported to query by sessionId or obtain sessonId using COHQL?
  2. Is it possible to get CoherenceWebSessionId using COHQL?


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

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