'enq: UL - contention' Locks On 'select DBMS_LOCK.REQUEST(:1 ,:2 ) from dual' Are Observed When ODI 11g Load Plans With Numerous Parallel Steps Are Used Under Heavy Execution Loads
Last updated on MARCH 16, 2017
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
An Oracle Data Integrator (ODI) Load Plan with numerous parallel steps is executed in an infinite loop.
After a couple of days running, the number of waits/locks on
is growing at a point that the Load Plan executions fail due to enq: UL - contentions.
After a restart of the ODI execution Agent, the executions immediately return to be normal behavior but after some time the issue is observed again.
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