Article Original Creation Date: 2014-10-21
Overview
This issue is replicated by the scenario below:
enq TX - allocate ITL entry on SPRT_NC_INFORM_EVENT table
After the introducing of the configuration change add JMS workflow manager: allow 128 requestors instead of 16. (To solve the issue with inform handling queued for long time.)
We now notice a Oracle error on the database stating: ‘enq: TX - allocate ITL entry’
These peaks occur when a high load of informs is reaching our platform.
See atatched doc.
Rebuild and INITRANS change is advised.
Environment
ServiceGateway 4.4.1
Root Cause
A significant increase in the number of database transactions performed against this table, due to an increase in the number of configured JMS consumers.
Resolution
The WebLogic JMS (work manager) configuration was modified to reduce the number of consumers on the ACSWorkflowQ queue from 128 to 32. The number of consumers on this queue had been increased from 16 to 128 in an attempt to resolve backlog issues. Once this change was implemented the "10169033: enq TX - allocate ITL" contention was not present in subsequent STATSPACK data.