My Oracle Support Banner

'enq: UL - contention' Locks On 'select DBMS_LOCK.REQUEST(:1 ,:2 ) from dual' Are Observed when ODI 11g / 12c Load Plans with Numerous Parallel Steps Are Used Under Heavy Execution Loads (Doc ID 1684246.1)

Last updated on SEPTEMBER 07, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.6.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.
The article applies to all releases of ODI like the current 12C as well as to previous releases.

Symptoms

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.

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!

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