OutOfMemory GetNewTla from PreparedXQueryCache (Doc ID 2198864.1)

Last updated on NOVEMBER 03, 2016

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

Actual behavior
---------------------------
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.

Business impact
------------------------
Business is highly impacted as OOF errors are freezing the Production.

Cause

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