My Oracle Support Banner

Memory Leak Caused by QueryDependency with SiteConfigurations (Doc ID 2192947.1)

Last updated on APRIL 04, 2019

Applies to:

Oracle Commerce Platform - Version 11.2 and later
Information in this document applies to any platform.


The memory usage may reach to nearly 100% within as short as a day. The heap analysis shows "atg.repository.query.QueryDependency" as top dominator component which holds huge number of SiteConfiguration objects as shown below:

Class Name         Objects   Shallow Heap   Retained Heap
QueryDependency  86               2,752           >= 368,602,832

The top QueryDependency object has more than 1M objects in its cache entry. The object belongs to SiteConfiguration item descriptor.


Prior to 11.2

siteConfiguration has query-cache-size is set to "1000":


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.