My Oracle Support Banner

OutOfMemory GetNewTla from PreparedXQueryCache (Doc ID 2198864.1)

Last updated on JUNE 03, 2024

Applies to:

Oracle Utilities Customer Care and Billing - Version 2.4.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On :  2.4.0.2.0 version, CA - Case Management

OutOfMemory getNewTla occurred in production environment.  

When looking into the heapdump at OutOfMemory, the suspicion is that com.splwg.base.support.scripting.PreparedXQueryCache$CacheAssoc is needed to be decrease, because heap histogram shows that PreparedXQueryCache is the one of the biggest class which seems to be used on Thread Local Area.

Steps to replicate
-------------------------
1. According to Doc 1980997.1 when OOM referencing PrepareQueryCache, the following changes/additions should be made in spl.properties:
com.oracle.XPath.LRUSize=2000
com.oracle.XPath.flushTimeout=86400
2. Check for OOM errors
3. Onsite these default values seem not to be sufficient.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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